Restorefiles command

Considerations

• The restorefiles command restores .mdf, ldf, and other flat files from a specified Tivoli Storage Manager 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 Tivoli Storage FlashCopy® Manager Remote Agent (VSS Requestor)
• 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 Tivoli Storage FlashCopy Manager (/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 configured the Tivoli Storage FlashCopy Manager 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.