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 |
|
Dejan
Starting Member
14 Posts |
 Posted - 2009-12-09 : 04:57:19
|
| Hi,I have back up file of my MS sql 2005 database. When I try to restore it I get error:-----------------------------------------------------------------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 'D:\xxxxx30.05.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.3080&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476------------------------------BUTTONS:OK------------------------------How to repair this backup file? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-12-09 : 06:46:59
|
| You can't. This is why you should check your backups actually work.Did you run out of space or have other issues while this backup was taking place?I assume you still have the database and other backups? go to an earlier/later one (depending on your requirements). |
 |
|
|
suretalu
Starting Member
2 Posts |
|
|
|
|
|
Incorrect BackUp file