RESTORE DATABASE命令还原SQLServer 2005 数据库

快来打我* 2022-04-24 06:28 253阅读 0赞

今天在sqlServer20005 的management studio里使用bak文件还原数据库的时候,总是失败!  
![BACKERROR.GIF][]  
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)  
  
找不到原因(已经选择了"overwrite the existing database"),只能使用命令来还原了,不知道为什么会这样.![12.gif][]

![None.gif][] \-- 返回由备份集内包含的数据库和日志文件列表组成的结果集。   
![None.gif][]\-- 主要获得逻辑文件名   
![None.gif][] USE  master  
![None.gif][] RESTORE  FILELISTONLY  
![None.gif][]    FROM   DISK   =   ' g:\\back.Bak '    
![None.gif][] Go   
![None.gif][] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*   
![ExpandedBlockStart.gif][] /\*  
![InBlock.gif][]利用bak恢复数据库，强制还原(REPLACE)  
![InBlock.gif][]STATS = 10 每完成10%显示一条记录  
![InBlock.gif][]DBTest和DBTest\_log是上面g:\\back.Bak里的逻辑文件  
![ExpandedBlockEnd.gif][]\*/   
![None.gif][] USE  master  
![None.gif][] RESTORE   DATABASE  DB   
![None.gif][]    FROM   DISK   =   ' g:\\back.Bak '   
![None.gif][]    WITH  MOVE  ' DBTest '   TO   ' E:\\Program Files\\Microsoft SQL Server2005\\Data\\DB.mdf ' ,   
![None.gif][]   MOVE  ' DBTest\_log '   TO   ' E:\\Program Files\\Microsoft SQL Server2005\\Data\\DB\_log.ldf ' ,  
![None.gif][]STATS  =   **10** ,  REPLACE   
![None.gif][] GO   
![None.gif][] \++++++++++++++++++++++++++++++++   
![None.gif][]  
![ExpandedBlockStart.gif][] /\*  
![InBlock.gif][]备份数据DB 到.bak文件。然后利用此bak文件恢复一个新的数据库DBTest。  
![ExpandedBlockEnd.gif][]\*/   
![None.gif][] USE  master  
![None.gif][] BACKUP   DATABASE  DB   
![None.gif][]   TO   DISK   =   ' g:\\DBBack0930.bak '    
![None.gif][] RESTORE  FILELISTONLY   
![None.gif][]   FROM   DISK   =   ' g:\\DBBack0930.bak '    
![None.gif][] RESTORE   DATABASE  DBTest   
![None.gif][]   FROM   DISK   =   ' g:\\DBBack0930.bak '    
![None.gif][]   WITH  MOVE  ' DBTest '   TO   ' E:\\Program Files\\Microsoft SQL Server2005\\Data\\DBTest.mdf ' ,   
![None.gif][]  MOVE  ' DBTest\_log '   TO   ' E:\\Program Files\\Microsoft SQL Server2005\\Data\\DBTest\_log.ldf '   
![None.gif][] GO    
![None.gif][] \-- \-\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

[BACKERROR.GIF]: /images/20220218/46bbf181281546e08a78b513ecca081e.png
[12.gif]: /images/20220218/53c53168f4db4fe9925f43cf871207d9.png
[None.gif]: /images/20220218/6d769072f1bb4bff83beb258152dc50f.png
[ExpandedBlockStart.gif]: /images/20220218/18691c4ed6c042c493dc8e8c23a42d16.png
[InBlock.gif]: /images/20220218/e3117d0d217b4c5ca4d3dbc12d23b2cf.png
[ExpandedBlockEnd.gif]: /images/20220218/7729aed2beb84d5691c7a90776efed54.png