在SQL Server 2008中还原SQL数据库 [英] restore SQL database in SQL server 2008

问题描述

大家好，

当我要在SQL Server 2008中还原数据库时，会发生此错误.当我备份数据库时，是否有任何准备??



标题:Microsoft SQL Server Management Studio
------------------------------
执行Transact-SQL语句或批处理时发生异常. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
其他信息:
设备上的媒体系列格式不正确. SQL Server无法处理此媒体系列.
RESTORE HEADERONLY异常终止.

hi all,

when i''m going to restore database in SQL server 2008 this error occur. Are there any foult when i''m back up data base.????



TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally.

推荐答案

尝试
还原(Transact-SQL)[ 如何:还原数据库备份(SQL Server Management Studio)[

Try
RESTORE (Transact-SQL)[^]
How to: Restore a Database Backup (SQL Server Management Studio)[^]

确保您就能正确连接到数据库-就像这里的连接字符串问题一样.

Make sure you are able to connect to the database properly - looks like a connection string issue here.

Google提供的帮助

Help by Google Problem with restore .bak file - SQL Server Central

Please check whether this helps or not.

这篇关于在SQL Server 2008中还原SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！