MSSQL 备份数据库还原

-- 完整还原
RESTORE DATABASE XXXX
FROM DISK = ‘d:XXXX.bak‘
WITH MOVE ‘XXXX‘ TO ‘D:MSSQLDataXXXX.mdf‘,
MOVE ‘XXXX_Log‘ TO ‘D:MSSQLDataXXXX.ldf‘,
REPLACE,NORECOVERY;
GO

 

查看备份文件信息

RESTORE FILELISTONLY FROM DISK = N‘d:XXXX.bak‘;

MSSQL 备份数据库还原

标签：

本文系统来源：http://www.cnblogs.com/Flyear/p/4606355.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！