0

i get this msg from sql server when i restore the back up file

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 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\TenderingSys' 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.5000&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476

how i can solve it ?

2
Contributors
2
Replies
3
Views
4 Years
Discussion Span
Last Post by HibaPro
0

Which version of SQL Server are you trying to restore to? If it is of an older version of MS SQL than your source database you will see this error. If in doubt use

SELECT @@VERSION

on both to make sure they are the same.

0

i have one 2005 , and other one 2008 i will upgrade the oldest one , ty

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.