HP StorageWorks Storage Mirroring application notes (T5437-96014, December 2009)

path. (For detailed information on connecting a source and target, see the HP StorageWorks
Storage Mirroring User’s Guide.)
10. If your desired target path is identical to the source path, select the One to One option in the
Mappings section.
If you want all of the source files to go to a single location, select the All to One option in the
Mappings section. You may edit the Target Path shown by clicking on it. Either type in the desired
target path, or browse to it using the button next to the path edit box.
11. On the Orphans tab, verify that the Move/Delete Orphan Files checkbox is NOT selected.
12. On the Mirroring tab, select the type of mirror, either Full or File Differences, to perform.
NOTE:
If the target has been previously mirrored to or restored, select File Differences with the
Use block checksum option so that only the changed data is sent across the network.
13. Click Connect to start the mirror and replication processes.
NOTE:
If you start SQL Server and attach and mount the replicated databases on the target, or if the
data on the target is otherwise modified, the data on the source and target will no longer match.
If the updated data on the target is not needed, perform a full or difference with block checksum
mirror from the source to the target. If the updated data on the target is needed, restore the data
from the target to the source.
Your situation may be such that your source data files and log files are at various disk/path locations,
and you want them to go to divergent disk/path locations on the target server. In this case, use the
paths that you recorded in “Install software on the source” on page 7 to help create separate
replication sets for each situation. Repeat steps 1-13 above to select the correct source file paths for
the replication sets and use the disk/file paths recorded in “Install software on the target” on page
8 to set the correct target file paths for each situation.
Detach the source databases (optional)
Optionally, you can detach the source databases. Detaching the database will close connections and
commit transactions in a cleaner way than replicating the live database, disconnecting the replication
set, and then attaching a previously-attached database.
Using SSMS on the source, use the stored procedure sp_detach_db to detach the user-created
databases from the source server. The account running the .bat file must be a member of the
sysadmin fixed server role.
The following sample script illustrates the syntax for detaching three databases, named Sales,
Accounting, and Marketing, from the source SQL 2005 server.
SAMPLE_DetachDB.sql
-- ***SAMPLE*** script for detaching SQL 2005 databases using Query Analyzer or the OSQL
-- command line utility.
-- This sample file is provided as an example only. Because no two
HP StorageWorks Storage Mirroring application notes 9