还原数据库:The backup set holds a backup of a database other than the existing database
来源:互联网 发布:linux ssh远程登录命令 编辑:程序博客网 时间:2024/05/16 23:42
查了好长时间资料才搞定这个问题。
使用SQL Server Management Studio的向导方式为新建的DB执行From Device Restore时,出现错误讯息:“The backup set holds a backup of a database other than the existing database”,使用以下方法解决:
1、删除新建的DB
2、直接右键Databases-->Restore Database
3、在弹出窗口中的To database栏位填写需要新建的DB名称(不存的名称)
4、选择From Device
5、选择DB的.bak备份文件
完成!
PS:至今不知道“先建DB然后再还原这种常用方式”总是报错的原因,但是这两种方式是殊途同归,都可以达到Restore的目的,这种方式是Restore的同时新建一个DB。
- 还原数据库:The backup set holds a backup of a database other than the existing database
- [TroubleShootin]The backup set holds a backup of a database other than the existing 'xxdb' database.
- The backup set holds a backup of a database other than the existing ‘dbName’ database
- 关于SQL Server还原错误:The backup set holds a backup of a database other than the existing database.
- System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ database
- SQL SERVER 2008恢复数据错误解决:The backup set holds a backup of a database other than the existing
- SQL SERVER恢复数据错误解决:The backup set holds a backup of a database other than the existing
- SQL SERVER 2005恢复数据错误解决:The backup set holds a backup of a database other than the existing 'XXX' database
- 109 You want to take a complete database backup using RMAN. The backup should consist only the used
- 166 You are managing a 24*7 database. The backup strategy for the database is to perform user-manage
- select a different database(other than MySQL)
- backup database
- BACKUP DATABASE
- SQL1116N A connection to or activation of database "T_1" cannot be made because of BACKUP PENDING.
- RMAN Restore backup of lower version database to a higher version
- SQL SERVER – Get Database Backup History for a Single Database
- 备份所有数据库 Backup all database
- 188 Examine the following scenario: The target database instance is running. The most recent backup
- jquery动态给指定的table添加一行tr td
- Project Euler problem 6
- CSS基础
- php fwrite写入txt文件的时候用 \r\n不能换行
- linux下shell脚本执行方法及exec和source命令
- 还原数据库:The backup set holds a backup of a database other than the existing database
- Create struts2-archetype-starter project in STS
- C# GEP基因化编程
- Timus 1791 汽车过桥的问题
- 通讯录管理系统
- 用Jquery获取Table指定行中指定列的数值
- windows可触屏幕应用开发1——win7 MT(多点触控技术)
- uva_624_CD
- Redmine Time Manager Tool Installation