RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
------------------------------------------
testDb----庫名
'c:\Northwind.bak' --------備份文件
'Northwind' TO 'c:\test\testdb.mdf' ---強制還原 mdf
'Northwind_log' TO 'c:\test\testdb.ldf' ---強制還原 ldf
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
------------------------------------------
testDb----庫名
'c:\Northwind.bak' --------備份文件
'Northwind' TO 'c:\test\testdb.mdf' ---強制還原 mdf
'Northwind_log' TO 'c:\test\testdb.ldf' ---強制還原 ldf
还原为:的数据库名和你要还原的数据库名一样不?不一样,改一下,试试!