还原数据库的sql语句

USE MASTER
RESTORE DATABASE test2
FROM DISK = 'D:\zzmj\zzmj.BAK'
WITH MOVE 'test2' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test2.mdf',
MOVE 'test2_LOG' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test2_log.ldf',
STATS = 10, REPLACE
GO

posted @ 2016-08-18 09:25  向之礼  阅读(724)  评论(0编辑  收藏  举报