Legacy restore output examples

Edit online

These output examples provide a sample of the text, messages, and process status that displays when using the restore command.

Restore ReportServer Full

Running this command restores a full backup of the model to a different server than that from which it was backed up.

Command:

tdpsqlc restore model full /fromsqlserver=STRINGVM1\STRINGVM1

Output:

IBM Storage Protect for Databases:
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Connecting to SQL Server, please wait...

Querying TSM Server for Backups ....

Starting Sql database restore...

Beginning VSS restore of 'model'...

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

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

Completed

Legacy Restore 2–Differential

Legacy Restore 2 displays restoring a differential backup object of database Test1 into database Test2. Note that the Test2 database must already exist for the restore to be successful.

Command:

tdpsqlc restore Test1 diff /into=Test2

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of database backups,
 please wait...

Beginning difffull restore of backup object Test1, 1 of 1,
  to database Test2
Full: 0   Read: 478720  Written: 478720  Rate: 40.62 Kb/Sec     
Restore of Test1 completed successfully.

Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                1
Total database skipped:                         0

Throughput rate:                                40.61 Kb/Sec
Total bytes transferred:                        478,720
LanFree bytes transferred:                      0
Elapsed processing time:                        11.51 Secs

Legacy Restore 3–Group

Legacy Restore 3 displays restoring a filegroup backup object named Group1 to database Test1.

Command:

tdpsqlc restore Test1 group=Group1

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of database backups,
 please wait...

Restoring meta data ...

Beginning group restore of backup object Test1\Group1, 1 of 1,
  to database Test1
Full: 0   Read: 86982144  Written: 86982144  Rate: 8,188.11 Kb/Sec     
Restore of Test1\Group1 completed successfully.

Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                1
Total database skipped:                         0

Throughput rate:                                8,185.75 Kb/Sec
Total bytes transferred:                        86,982,144
LanFree bytes transferred:                      0
Elapsed processing time:                        10.38 Secs

Legacy Restore 4–Set

Legacy Restore 4 displays restoring all active set backup objects to database Test1.

Command:


tdpsqlc restore Test1 set=*

Output:

IBM IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of database backups,
 please wait...

Restoring meta data ...

Beginning set restore of backup object Test1\20120718141546\00000700, 
1 of 1,to database Test1
Full: 0   Read: 88489472  Written: 88489472  Rate: 8,125.58 Kb/Sec     
Restore of Test1\20120718141546\00000700 completed successfully.

Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                1
Total database skipped:                         0

Throughput rate:                                8,122.52 Kb/Sec
Total bytes transferred:                        88,489,472
LanFree bytes transferred:                      0
Elapsed processing time:                        10.64 Secs

Legacy Restore 5–Log (point in time)

Legacy Restore 5 displays restoring all active log backup objects of database Test1 to a specified point in time. Three of four log backups meet the datetime criteria.

Command:

tdpsqlc restore Test1 log=* /stopat="07/01/2012 13:56:00"

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of 
database backups, please wait...

Beginning log restore of backup object Test1\20120701135511\
	00000700, 
1 of 4,to database Test1
Full: 0   Read: 214528  Written: 214528  Rate: 59.75 Kb/Sec     
Restore of Test1\20120701135511\00000700 completed successfully.

Beginning log restore of backup object Test1\20120701135605\
	00000700, 
2 of 4,to database Test1
Full: 0   Read: 147968  Written: 147968  Rate: 32.15 Kb/Sec      
Restore of Test1\20120701135605\00000700 completed successfully.

Beginning log restore of backup object Test1\20120701135712\
	00000700, 
3 of 4,to database Test1
Full: 0   Read: 0  Written: 0  Rate: 0.00 Kb/Sec      
Restore of Test1\20120701135712\00000700 completed successfully.

Skipping Test1\20120701135817\00000700
because of the preceding failure or point-in-time recovery.

Total database backups inspected:               4
Total database backups requested for restore:   4
Total database backups restored:                3
Total database skipped:                         1

Throughput rate:                                37.21 Kb/Sec
Total bytes transferred:                        362,496
LanFree bytes transferred:                      0
Elapsed processing time:                        9.51 Secs

Legacy Restore 6–Log (named mark)

Legacy Restore 6 displays restoring all active log backup objects to database Testmark to a named point in time. The first mark with the specified name, mark2, is encountered in the third log backup object applied to the restore. The restore stops once this mark is encountered.

Command:

tdpsqlc restore Testmark log=* /stopatmark=mark2

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of database 
backups, please wait...

Beginning log restore of backup object Testmark\20120701102947\
	0000065C, 1 of 4, to database Testmark
Full: 0   Read: 159232  Written: 159232  Rate: 61.68 Kb/Sec
Restore of Testmark\20120701102947\0000065C completed successfully.

Beginning log restore of backup object Testmark\20120701103127\
	000001DC, 2 of 4, to database Testmark
Full: 0   Read: 159232  Written: 159232  Rate: 34.51 Kb/Sec
Restore of Testmark\20120701103127\000001DC completed successfully.

Beginning log restore of backup object Testmark\20120701103325\
	00000680, 3 of 4, to database Testmark
Full: 0   Read: 0  Written: 0  Rate: 0.00 Kb/Sec
Restore of Testmark\20120701103325\00000680 completed successfully.

Skipping Testmark\20120701103556\00000694
because of the preceding failure or point-in-time recovery.

Total database backups inspected:               4
Total database backups requested for restore:   4
Total database backups restored:                3
Total database skipped:                         4

Throughput rate:                                38.60 Kb/Sec
Total bytes transferred:                        318,464
LanFree bytes transferred:                      0
Elapsed processing time:                        8.06 Secs

Legacy Restore 7–Log (inactive object)

Legacy Restore 7 begins with a query to display both active and inactive log backup objects for database Test1.

Command:

tdpsqlc q tsm netapp_db2 log=* /all

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Connecting to TSM Server as node 'STRINGVM1_SQL'...

Backup Object Information
-------------------------

SQL Server Name   ........................ STRINGVM1\STRINGVM1
SQL Database Name ........................ netapp_db2
Backup Method     ........................ Lgcy
Backup Location   ........................ Srv
Backup Object Type ....................... Log      
Backup Object State ...................... Active
Backup Creation Date / Time .............. 09/27/2012 08:36:28
Backup Size .............................. 82.50 KB
SQL Compressed ........................... No
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20120927083628\00001A4C
Number of stripes in backup object ....... 1
Assigned Management Class  ............... DEFAULT

The restore operation for Legacy Restore 7 applies a specifically named inactive log backup object of database Test1 to the restore. Since an inactive log backup object is being requested, the /object parameter must be used on the restore command.

Command:

tdpsqlc restore Test1 log=* /object=20120622135511\00000700

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of database 
	backups,please wait...

Beginning log restore of backup object Test1\20120622135511\
	00000700,1 of 1,to database Test1
Full: 0   Read: 214528  Written: 214528  Rate: 29.47 Kb/Sec      
Restore of Test1\20120622135511\00000700 completed successfully.

Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                1
Total database skipped:                         0

Throughput rate:                                29.46 Kb/Sec
Total bytes transferred:                        214,528
LanFree bytes transferred:                      0
Elapsed processing time:                        7.11 Secs

Legacy Restore 8–Full (partial)

Legacy Restore 8 displays restoring part of a full backup object, filegroup Group1, to database Test1.

Command:

tdpsqlc restore Test1 full /partial /gr=Group1

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of database 
	backups,please wait...

Restoring meta data ...

Beginning full restore of backup object Test1, 1 of 1,
  to database Test1
Full: 0   Read: 89607680  Written: 89607680 Rate: 3,359.60 Kb/Sec 
Restore of Test1 completed successfully.


Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                1
Total database skipped:                         0

Throughput rate:                                3,359.21 Kb/Sec
Total bytes transferred:                        89,607,680
LanFree bytes transferred:                      0
Elapsed processing time:                        26.05 Secs

Legacy Restore 9–Full (relocate)

Legacy Restore 9 displays restoring a full backup object of database Test1, specifically relocating logical file File1Group1 to a new physical location.

Command:

tdpsqlc restore Test1 full /relocate=File1Group1 
/to=e:\sqldata\File1Group1.NDF

Output:

IBM Storage Protect for Databases
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

Starting Sql database restore...

Querying IBM Storage Protect server for a list of database 
	backups,please wait...

Restoring meta data ...

Beginning full restore of backup object Test1, 1 of 1,
  to database Test1
Full: 0   Read: 88100352  Written: 88100352  Rate: 3,930.18 Kb/Sec      
Restore of Test1 completed successfully.

Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                1
Total database skipped:                         0

Throughput rate:                                3,929.64 Kb/Sec
Total bytes transferred:                        88,100,352
LanFree bytes transferred:                      0
Elapsed processing time:                        21.89 Secs