Vxsnap restore command reference


Vxsnap restore command reference
Prev	Recovering a SQL Server database	Next

The following is a summary of the vxsnap restore command syntax and attribute descriptions.

The command syntax is as follows:

vxsnap -x Filename [-b] [-f] [-r] restore
{RestoreType=[RECOVERY|NO_RECOVERY]}
[noLogs|logFiles=tlog1,tlog2,...] writer=WriterName

The following attributes apply:

-x Filename	The metadata file created by the vxsnap create command. Each snapshot set must have a unique name for the metadata file.
-b	Resynchronizes the volume in the background. A new snapshot cannot be made until the resynchronization is complete.
-f	Forces the operation. Make sure the volume is not in use before using this option.
-r	Recover even if original volume is not present. If this option is selected and the original volume is not present, the snapshot volume of the missing volume is changed from a read-only volume to a read-write volume. Use this option only with Recovery noLogs. After using this option you must explicitly assign the original drive letter/mount path of the missing volume to the snapshot volume in the VEA and then bring the database online.
RestoreType= [RECOVERY\|NO_RECOVERY]	Specifies the type of database recovery, either recovery or no recovery: RECOVERY can be used with either the noLogs or logFiles=tlog1,tlog2,.... attributes. NO_RECOVERY restores from the specified snapshot set to the time of the snapshot. No logs are applied and the database is left in an loading state so that you can manually replay backup logs to a specific point in time.
*noLogs*	Database and transaction log files are restored from the snapshot set. No transaction backup logs are applied. The database is left in an operational state.
logFiles=tlog1,tlog2,...	Transaction log backup files to be applied with the RECOVERY option to achieve a point of failure recovery. Each transaction log must have a unique name and be created using the "overwrite existing media" option within SQL Server. The database is left in an online state.
writer=WriterName	The name for the SQL Server VSS Writer; used to located the default directory to search for the XML metadata file. Specify `SQLServerWriter`.

Prev	Up	Next
Post-recovery steps	Home	Vxsnap utility command line reference for SQL Server