Member Avatar for HibaPro

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
  • 293 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by HibaPro
Member Avatar for hericles

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.

Member Avatar for HibaPro

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.