恢复备份的数据库

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/archive/2009/06/08/1498440.html