10400414-002 05/2013
©2013 Overland Storage, Inc.
3-17
SnapSAN S5000 Data Migration User Guide
For SQL Server (example)
Attach the database.
sqlcmd -E -b -Q"EXEC sp_attach_db <database-name>, '<mdf-file-
path>', '<ldf-file-path>'"
1.
Check that the database contents remain the same as before migration.
2.
For setting the cluster, perform the following steps:
a.
Temporarily stop the database.
b.
Enable the disk and database monitor settings.
c.
Start the group.
3.
Check that operations can be resumed on the application server.
4.
To use a logical disk name unique within the system for operation, allocate the logical
disk name used on the source disk array to the destination logical disk name.
5.
To manage the source and destination disk arrays with a single SnapSAN Manager
server, duplicate logical disk names are not allowed. Rename the source logical disk
(for example, from DATA_1 to DATA_1_OLD) and then rename the logical disk name
in the destination disk array (for example, from DATA_1_NEW to DATA_1).
6.
Start operations for which data is completely migrated.
Migration Processing Stopping Operations
This section provides an overview of data migration processing stopping operations (without
stopping the server).
