MSSQL 備份數據庫還原

-- 完整還原
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';