还原数据库的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

还原数据库的sql语句

原文：http://www.cnblogs.com/forthelichking/p/5782743.html