问题描述
我有.MDF和.LDF文件的SQL数据库备份.当我尝试还原时,它显示了类似
的错误
执行Transact-SQL语句或批处理时发生异常. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
其他信息:
设备"E:\ ElectionDB \ SAMPLE.mdf"上的媒体系列格式错误. SQL Server无法处理此媒体系列.
RESTORE HEADERONLY正在异常终止. (Microsoft SQL Server,错误:3241)
实际上,我尝试从SQL2003还原到SQL2005.
我用来还原为...
1.使用一些(SAMPLE)名称创建新数据库.(我在这里不确定我是否应该使用相同的数据库名称)
2.虽然我尝试通过右键单击->任务->恢复->数据库来恢复它.它显示了我上面提到的错误.
3.即使我只是将那些文件(.MDF和.LDF)复制并粘贴到Programfiles ---> MSSQL-> DATA-> SAMPLE.MDF& SAMPLE.LDF ....但是没有运气
请帮帮我....
I have an SQL database backup of .MDF and .LDF files. While i tried to restore, it shows error like
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device ''E:\ElectionDB\SAMPLE.mdf'' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
Actually i tried to restore from SQL2003 to SQL2005.
I use to restore as...
1.Create new database with some(SAMPLE) name.(I have an doubt here, whether i should have same database name)
2. While i tried to restore it by rightclick-->tasks-->restore-->database. It shows an error as i mentioned above.
3. Even i just copy and Paste those files(.MDF and .LDF) to Programfiles--->MSSQL-->DATA-->SAMPLE.MDF & SAMPLE.LDF.....but no luck
Please help me out....
推荐答案
这篇关于还原SQL数据库时出现问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!