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