Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2010-12-21 : 06:23:41
|
| TITLE: Microsoft SQL Server Management Studio Express------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------ADDITIONAL INFORMATION:The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\SQL2008R2_768066_burnbet_backup.bak' is incorrectly formed. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476------------------------------BUTTONS:OK------------------------------ |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-12-21 : 06:47:45
|
| Assuming you're asking a question: your backup file is corrupted and unusable. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-21 : 07:51:04
|
| From the name of the backup, it appears that the problem is that you're trying to restore a backup of a SQL 2008 R2 database onto SQL 2005. Downgrades are not possible.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Restore bak