我在SQL Server 2012上还原没有问题。你试一下用以下的T-SQL还原数据库,看看结果。USE master; GORESTORE FILELISTONLY FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup\DB1.bak' RESTORE DATABASE DB2 FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup\DB1.bak' WITH replace, RECOVERY, MOVE 'DB1' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\DB2.mdf', MOVE 'DB1_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\DB2_log.ldf'; GO
这个甭管是2008R2还是2012肯定是可以还原的你先把错误信息贴出来看看
GORESTORE FILELISTONLY
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup\DB1.bak'
RESTORE DATABASE DB2
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup\DB1.bak'
WITH replace,
RECOVERY,
MOVE 'DB1' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\DB2.mdf',
MOVE 'DB1_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\DB2_log.ldf';
GO