Microsoft SQL Server Management Studio Error

Asked By petersullivaa 30 points N/A Posted on - 08/21/2011

Hi dear,

Need Help with Microsoft SQL Server Studio. Please tell me the solution to this error, how can I remove this error.

Detail of Error:

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 FilesMicrosoft SQL ServerMSSQLBACKUPMasterct.bak’ is incorrectly formed. SQL Server cannot process this media family.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3241)

OK

• Status: Open
• Question Views: 2017
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Robert Powell 0 points N/A #96123

Microsoft SQL Server Management Studio Error

So you are restoring a database from a backup file.

Here are a few suggestions that could help you:

1. Make sure the backup file is not corrupted. To check if it is not corrupted, you may run this Transact-SQL statement: “RESTORE VERIFYONLY”. This would check if the backup is complete and entirely readable.

2. I'm just guessing you are using multiple SQL server versions, when you backup database and restore. If this is the scenario, you backup your database from the development server using SQL Server 2008 or 2005, and restore the database to the production server with SQL server lower version, then you will really get that error message.

3. That is because lower version cannot recognize backups from higher version. If this is the case, you can use SQL Server Database Publishing Wizard. It can deploy SQL server database to your production server on lower versions like SQL Server 2000 or SQL Server 2005.

About Robert Powell

Questions
0

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/22/2011
• Question Category: MS SQL Server