-- 完整还原
RESTORE DATABASE XXXX
FROM DISK = ‘d:\XXXX.bak‘
WITH MOVE ‘XXXX‘ TO ‘D:\MSSQL\Data\XXXX.mdf‘,
MOVE ‘XXXX_Log‘ TO ‘D:\MSSQL\Data\XXXX.ldf‘,
REPLACE,NORECOVERY;
GO
查看备份文件信息
RESTORE FILELISTONLY FROM DISK = N‘d:\XXXX.bak‘;
原文：http://www.cnblogs.com/Flyear/p/4606355.html