使用命令行界面复原数据

如果愿意，您可以使用命令行界面从虚拟机启动完全 Microsoft SQL Server 数据库恢复。

过程

  1. 发出 query 命令以查找完全和日志数据库备份 以下示例会查找名为 sql_db10 的 Microsoft SQL Server 数据库的所有备份。
    tdpsqlc q tsm sql_db10

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 0.0

...

Querying TSM Server for Backups ....
Backup Object Information
-------------------------
SQL Server Name ........................ SQL10
SQL Database Name ........................ sql_db10
Backup Method ........................ VMVSS
...
Backup Creation Date / Time .............. 11/14/2014 13:41:18
...
Backup Object Information
-------------------------
SQL Server Name ........................ SQL10
SQL Database Name ........................sql_db10
Backup Method ........................ Lgcy
...
Backup on Secondary Replica .............. No
Backup Object State ...................... Active
Backup Creation Date / Time .............. 11/14/2014 15:46:07
...
The operation completed successfully. (rc = 0)
  2. 发出 restore /recovery=no 命令，如以下示例中所示。 
     tdpsqlc restore databaseName /backupMethod=vmvss 
/recovery=no

    以下示例显示指定名为 sql_db10 的 Microsoft SQL Server 数据库时的命令输出。

    tdpsqlc restore sql_db10 /backupmethod=vmvss /sqlserver=sql10 
	/fromsqlserver=sql10 /recovery=no

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

Connecting to SQL Server, please wait...

Querying TSM Server for Backups ....

Connecting to TSM Server as node “SQL10_SQL”...
Connecting to Local DSM Agent “SQL10”...
Using backup node “SQL10_SQL”...
Starting Sql database restore...

Beginning VSS restore of “sql_db10”...

Restoring “sql_db10” via file-level copy from snapshot(s). This 
	process may take some time. Please wait

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

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

The operation completed successfully. (rc = 0)
  3. 成功完成完全数据库复原操作后，发出命令以复原日志。 例如，要在已复原的 Microsoft SQL 数据库 sql_db10 上复原所有日志，请发出以下命令：
     tdpsqlc restore databaseName /backupMethod=vmvss 
/recovery=no
    您还可以使用 /stopat 选项来指定更详细的时间点。 
    tdpsqlc restore sql_db10 log=* /sqlserver=sql10 
	/fromsqlserver=sql10 /recovery=yes

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

Connecting to SQL Server, please wait...

Starting Sql database restore...

Connecting to TSM Server as node “SQL10_SQL”...
Querying Tivoli Storage Manager server for a list 
	of database backups, please wait...

Beginning log restore of backup object sql_db10\20131114154607\00000DB0, 
	1 of 3, to database sql_db10
...

Beginning log restore of backup object sql_db10\20131114155130\00000DB0, 
	2 of 3, to database sql_db10
....

Total database backups inspected: 						3
Total database backups requested for restore: 	3
Total database backups restored: 							3
Total database skipped: 											0
Throughput rate: 														134.32 Kb/Sec
Total bytes transferred: 										385,536
Total LanFree bytes transferred: 							0
Elapsed processing time: 										2.80 Secs

The operation completed successfully. (rc = 0)

下一步做什么

您可以使用 Data Protection for Microsoft SQL Server 命令行界面 TDPSQLC 来复原不活动的备份。发出 restore 命令时，指定特定备份的数据库对象。
要获取数据库对象名称，请发出以下命令：
tdpsqlc q tsm dbname full /all
具有数据库对象名称值后，在 TDPSQLC restore 命令的 /OBJect=objectname 参数上指定数据库对象名称，其中 objectname 是数据库对象名称。例如：
tdpsqlc restore db44 /object=20140311131051 /backupdestination=tsm
 /backupmethod=vmvss
限制： 不能将 Microsoft SQL 数据库恢复到虚拟机的其他位置。