Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot restore SQL 2008 DB to SQL 2008 R2- media family error

Status
Not open for further replies.

achick

Programmer
May 23, 2007
66
0
0
US
I have a full back up of a large database in SQL server 2008.
the back up was done using standard optinos in Task-> Backup

When I try to restore in SQL 2008 R2, it goes fine almost till the end( The files are created) and then I get this error.

The media family on device is incorrectly formed.
 
1.) is this a "The database is now corrupt and I'm trying to fix it situ" or are you do a "make/update a test environment restore"

2.) Have tried taking another backup? It's entirely possible there is an error in your current backup.

Lodlaiden

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top