恢复备份的数据库

RESTORE DATABASE test
 FROM DISK ='全备份文件'
  WITH NORECOVERY
  ,MOVE 'test_data' TO 'd:"test.mdf',
  MOVE 'test_log' TO 'd:"test.ldf'
RESTORE DATABASE test
   FROM DISK ='差异备份文件'
原文地址:https://www.cnblogs.com/lfzwenzhu/p/1498440.html