Hi SQL Gurus, I have problem with backup during restore, so I will describe the scenario that I had today:
I take backup for one DB in my machine where I have installed the SQL Server 2008, and trying to restore in another machine where is installed SQL Server 2005 with SP3, and during restore I have problem with error number 3241:
Msg 3241, Level 16, State 7, Line 1
The media family on device 'D:\SQLDatabases\Database.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
I try to restart machine and services, shrinking database (just in case), changing compatibility mode (just in case), Restoring with verify only and it works fine in my machine ( I don't know what next...?), I try to restore in SQL Server 2008 and it works ok ( so seems we do not have any corrupt file)!!!
Any experience about this issue!?
Did you have issue like this with SQL Server 2008 and SQL Server 2005!
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =