User's Manual

7.17
Recovery Manager Commands
3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide
3PAR Confidential
-s <SQL Server> - SQL server to which the database belongs.
Optional: Uses the current server name as the default.
-i <SQL instance> - SQL server instance to which the database belongs.
Optional: Uses MSSQLSERVER as the default if not specified.
-d <database> - The database from which to create a virtual copy.
Optional: Without the
-d parameter, the instance level restore will be performed.
-t <timestamp> - The timestamp for the virtual copy to restore.
-ts <target server> - Target Server to do the restore (Media Restore only).
Optional: Uses the current server name as the default.
-M <masterServer> - Specifies the NBU master server name.
-a <altLocation> - Specifies an alternate restore location.
-snap - Promotes the snapshot back to the base volume for faster restore.
EXAMPLES
The following command performs a restore of virtual copy 020405162103 to drive j:\.
RMSql restore -s server1 -d test_db -t 020405162103 -M server1 -a J:\
The following command performs a file copy restore of virtual copy 020405162103.
RMSql restore -s server1 -d test_db -t 020405162103
The following command performs a snap volume restore of virtual copy 020405162103.
RMSql restore -snap -s server1 -d test_db -t 020405162103
NOTE: For both instance-level and database-level volume restore, if some
volume(s) involved are Remote-Copy-bounded, they need to be configured as one
single RC group.
NOTE: For the -snap option for volume restore, you can only promote a base
volume that is exposed to a host.