SQL SERVER 2008 数据恢复出错:
-------------------------------------------------------------------------------------------------------------------------
还原对于服务器‘MOTEST’ 失败,
。。。。。
备份集中的数据库备份与现有的“DATABASENAME”数据库不同
RESTORE DATABASE 正在异常终止。(MICROSOFT SQL SERVER ,错误:3154)
-------------------------------------------------------------------------------------------------------------------------
后用系统administrator登录。使用代码恢复完成。
USE MASTER
RESTORE DATABASE [databasename]
FROM DISK = 'D:\bak\bak2013.bak'
WITH MOVE '[databasename]' TO 'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\[databasename].MDF',
MOVE '[databasename]_LOG' TO 'D:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\[databasename]_log.LDF',
STATS = 10, REPLACE
GO