今天在sqlServer20005 的management studio里使用bak文件還原數(shù)據(jù)庫的時候,總是失敗!

Restore failed for Server 'ADANDELI'.? (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo
The backup set holds a backup of a database other than the existing 'AAA' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server，錯誤: 3154)

找不到原因(已經(jīng)選擇了"overwrite the existing database"),只能使用命令來還原了,不知道為什么會這樣.

--返回由備份集內包含的數(shù)據(jù)庫和日志文件列表組成的結果集。
--主要獲得邏輯文件名
USE?master
RESTORE?FILELISTONLY
???FROM?DISK?=?'g:\back.Bak'?
Go
************************************************
/**//*
利用bak恢復數(shù)據(jù)庫，強制還原(REPLACE)
STATS?=?10?每完成10%顯示一條記錄
DBTest和DBTest_log是上面g:\back.Bak里的邏輯文件
*/
USE?master
RESTORE?DATABASE?DB?
???FROM?DISK?=?'g:\back.Bak'
???WITH?MOVE?'DBTest'?TO?'E:\Program?Files\Microsoft?SQL?Server2005\Data\DB.mdf',?
???MOVE?'DBTest_log'?TO?'E:\Program?Files\Microsoft?SQL?Server2005\Data\DB_log.ldf',
STATS?=?10,?REPLACE
GO
++++++++++++++++++++++++++++++++

/**//*
備份數(shù)據(jù)DB?到.bak文件。然后利用此bak文件恢復一個新的數(shù)據(jù)庫DBTest。
*/
USE?master
BACKUP?DATABASE?DB?
??TO?DISK?=?'g:\DBBack0930.bak'?
RESTORE?FILELISTONLY?
??FROM?DISK?=?'g:\DBBack0930.bak'?
RESTORE?DATABASE?DBTest?
??FROM?DISK?=?'g:\DBBack0930.bak'?
??WITH?MOVE?'DBTest'?TO?'E:\Program?Files\Microsoft?SQL?Server2005\Data\DBTest.mdf',?
??MOVE?'DBTest_log'?TO?'E:\Program?Files\Microsoft?SQL?Server2005\Data\DBTest_log.ldf'
GO?
---******************************

轉載于:https://www.cnblogs.com/adandelion/archive/2006/09/30/519534.html

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎勵來咯，堅持創(chuàng)作打卡瓜分現(xiàn)金大獎

總結

以上是生活随笔為你收集整理的RESTORE DATABASE命令还原SQLServer 2005 数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內容還不錯，歡迎將生活随笔推薦給好友。