HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

4. Back up the metafile created at the restoration to the temporary folder.
Back up the metafile created at the restoration to the temporary folder for extended commands
that is on the backup server, so that the metafile and temporary files can be transmitted collectively
to the database server. To back up the metafile, execute EX_DRM_SQLFILE_PACK on the backup
server. Note, however, that you do not need to execute this command if you did not register the
VDI metafile storage directory when executing the drmsqlinit command.
BKServer > EX_DRM_SQLFILE_PACK Operation_A
5. On the database server, receive the metafile and temporary files.
To receive the metafile and temporary files collectively from the backup server, execute
EX_DRM_FTP_GET on the database server. In this example, the user ID to log on to the FTP server
is admin and the login password is password. The metafile and temporary files are stored in
the temporary folder for extended commands, on the database server.
DBServer > EX_DRM_FTP_GET Operation_A -server BKServer -user admin -password password
6. Import the temporary files, which were transmitted from the backup server, into the backup catalog
on the database server.
To import the temporary files, which were transmitted from the backup server, into the backup
catalog on the database server, execute EX_DRM_DB_IMPORT on the database server.
DBServer >EX_DRM_DB_IMPORT Operation_A
7. On the database server, deploy the metafile that was transmitted from the backup server.
To deploy the metafile transmitted from the backup server, execute EX_DRM_SQLFILE_EXTRACT
on the database server.
DBServer > EX_DRM_SQLFILE_EXTRACT Operation_A
8. Restore the data from the secondary volume to the primary volume.
Restore the data by resynchronizing the primary and secondary volumes. To restore the data,
execute EX_DRM_SQL_RESTORE on the database server.
DBServer > EX_DRM_SQL_RESTORE Operation_A -resync
When EX_DRM_SQL_RESTORE is executed with the -undo option specified, restoration is
performed while the database is in the standby status, in which the database is read-only. If the
-undo option is omitted, after restoration, the status of the database changes to loading, and
the database cannot be viewed.
Also, be sure not to connect to SQL Server while executing EX_DRM_SQL_RESTORE.
9. Recover the SQL Server database.
To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool
command.
The following shows an example of the drmsqlrecover command and drmsqlrecovertool
dialog box. For details on the drmsqlrecover command or the drmsqlrecovertool dialog box,
see the HP StorageWorks P9000 Replication Manager Software CLI Reference Guide.
Operation for SQL Server databases302