Sql Server 2008 还原数据库 3154错误
- WBOYOriginal
- 2016-06-07 17:37:221668browse
sqlserver2008还原数据库时出现了3154错误，具体错误信息如下： 错误信息 The backup set holds a backup of a database other than the existing ‘XXXXX’database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server，错误: 3154) 解决
sqlserver2008还原数据库时出现了3154错误，具体错误信息如下：
错误信息The backup set holds a backup of a database other than the existing ‘XXXXX’database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server，错误: 3154)
解决方法1. 不在数据库名字上右键点击还原，而是在上一层目录“数据库”上右键还原，然后选择要还原的数据库，，和备份文件。（不明白为什么在数据库名字上和在“数据库”上进行还原会有不同。不过这招确实能解决问题！）
2. 执行下面sql语句：(这招没试过，比较懒不想敲)
restore database XXXXX from disk = ‘{file path}’with replace;
参考
?controller=content&action=show&id=791
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： 无归档,无备份，rm误删除所有数据文件恢复(四）Next article： MYSQL数据库表设计优化