Restorefiles command

Use the restorefiles command to restore VSS-based backups on theIBM Storage Protect (/BACKUPDESTINATION=TSM), or stored locally (/BACKUPDESTINATION=LOCAL).

Considerations

• The restorefiles command restores .mdf, ldf, and other flat files from a specified IBM Storage Protect VSS-based backup into a specified directory.
• A destination directory can be specified as a directory on a fixed file system such as C:\temp, or on a network share that is accessible to the IBM Storage Protect Snapshot Remote Agent (VSS Requestor). It is not possible to use a mapped network drive as a destination directory.
• The restorefiles command does not restore the data to the SQL Server.
• This command does not require the SQL Server to be installed on the system where the restorefiles command is run.
• A restore continues until it is completed unless the destination volume does not have enough space to fulfill the restore operation.
• VSS-based backups that are on the IBM Storage Protect Snapshot (/BACKUPDESTINATION=TSM) can be restored by using restorefiles on the same system that ran the VSS-based backup, or by running the command on a system that installed and configurted the IBM Storage Protect Snapshot client.
• The directory that is specified in the restorefiles command appended the VSS component name so that multiple databases can be restored to the same target directory.
• VSS-based backups that are stored on the local system by using a persistent snapshot (/BACKUPDESTINATION=LOCAL), can be restored only by running the restorefiles command on the same system that ran the VSS-based backup, and has access to the persistent snapshot.
• To run a full restore:

  tdpsqlc
                       restorefiles DBName1 FULL /backupmethod=vss
                       /relocatedir=d:\temprestore

• Use /RELOCATEDIR to specify the destination directory for the flat files. If this option is not specified, the destination directory defaults to the current working directory.
• If you are in a non-clustered environment, you can restore only a local snapshot to the system that generated the snapshot. Or for cluster environments, you can run a restorefiles command from any of the systems in the cluster.