VSS restore output examples

Restore database msdb from IBM Storage Protect server storage using the optional parameters, /backupdestination and /backupmethod.

Command:

tdpsqlc restore msdb full /backupdestination=tsm /backupmethod=vss

Output:

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015. 
All rights reserved.

Connecting to SQL Server, please wait...

Querying TSM Server for Backups ....

Starting Sql database restore...

Beginning VSS restore of 'msdb'...

   Files Examined/Completed/Failed: [ 2 / 2 / 0 ]   Total Bytes: 8062302

VSS Restore operation completed with rc = 0
   Files Examined      : 2
   Files Completed     : 2
   Files Failed        : 0
   Total Bytes         : 8062302
   Total LanFree Bytes : 0

Completed

Restore database DEMODB from local shadow volumes using the new optional parameters, /backupdestination and /backupmethod.

Command:

tdpsqlc restore DEMODB full /backupdestination=local
 /backupmethod=vss /instantrestore=no

Output:

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015.
All rights reserved.

Connecting to SQL Server, please wait...

Querying TSM Server for Backups ....

Starting Sql database restore...


Beginning VSS restore of 'DEMODB'...


Files Examined/Completed/Failed: [ 2 / 2 / 0 ] Total Bytes: 5243190

VSS Restore operation completed with rc = 0
Files Examined: 2
Files Completed: 2
Files Failed: 0
Total Bytes: 5243190
Total LanFree Bytes: 0

Use instant restore to restore database testdb2 from local shadow volumes using the new /instantrestore parameter.

Command:

tdpsqlc restore testdb2 /backupmethod=vss 
/backupdest=local /instantrestore=yes

Output:

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015.
All rights reserved.

Connecting to SQL Server, please wait...

Querying TSM Server for Backups ....

Starting Sql database restore...


Beginning VSS restore of 'DEMODB'...



Restoring 'DEMODB' using volume-level-copy snapshot.


Starting snapshot restore process. This process may take several minutes.



VSS Restore operation completed with rc = 0
Files Examined : 0
Files Completed : 0
Files Failed : 0
Total Bytes : 0
Total LanFree Bytes   : 0

Restore and relocates database svtdb from IBM Storage Protect server storage to directory m:\svtdb using the new optional parameter, /relocatedir. All SQL logs and full-text index files associated with database svtdb are also restored and relocated.

Command:

tdpsqlc restore svtdb full /relocatedir=m:\svtdb /backupdestination=tsm
 /backupmethod=vss

Output:

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015.
All rights reserved.

Connecting to SQL Server, please wait...

Querying TSM Server for Backups ....

Starting Sql database restore...


Beginning VSS restore of 'svtdb'...



Preparing for restore of 'svtdb' from TSM backup.

   Files Examined/Completed/Failed: [ 5 / 5 / 0 ]   Total Bytes: 418328259

VSS Restore operation completed with rc = 0
   Files Examined   : 5
   Files Completed  : 5
   Files Failed     : 0
   Total Bytes      : 418328259
	 Total LanFree Bytes   : 0

To restore and relocate the database svtdb, its logs, and its full-text index files into their own respective locations, the following command is issued:

tdpsqlc restore svtdb full /relocatedir=m:\svtdb,e:\svtdb,f:\svtdb 
/backupdestination=tsm /backupmethod=vss

The /relocatedir values in this command are as follows:

• m:\svtdb: The directory where only the svtdb database is relocated.
• e:\svtdb: The directory where only the svtdb logs are relocated.
• f:\svtdb: The directory where only the svtdb full-text index files are relocated.