我无法还原备份的数据库
问题描述:
大家好,
我想备份数据库并再次还原它,但是在备份并尝试还原后出现错误消息:
Hi guys,
I want to backup Database and restore it again, but after backup and try to restore it error message appear:
SqlError The media set has 2 media families but only 1 are provided
我无法再次还原我的数据库.
我使用SQL Server 2005
I can not to restore my database again.
I use SQL Server 2005
答
创建备份时,可能在底部显示的列表中添加了两个不同的备份文件,现在使用只有一个文件.请检查.删除所有现有备份后重新创建备份.希望它能解决您的问题.乐意提供帮助.........
when u created backup it may be possible that in the list displayed in bottom you had two different backup files added and now you are restoring with only one file. please check. re create backup after deleting all existing backups. hope it solves your problem. happy to help.........
选择mdf文件位置
和日志文件位置
chose mdf file location
and log file location