October 22, 2009 at 10:04 am
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!?
:hehe:
Did you have issue like this with SQL Server 2008 and SQL Server 2005!
October 22, 2009 at 10:21 am
SQL 2008 backups are not backward compatible so you can't restore them to SQL 2005. If you're not using any new features of 2008, you might be able to export the schema and data instead. For more information, refer to the following:
October 22, 2009 at 10:51 am
Link info is useful, I will try with Export data or everything to script definitions and data...will try and I will see what happening ...
I know this fact but that the backup from SQL Server 2008 will not work in SQL Server 2005, but just if you create the DB in SQL Server 2008. Little bit confusing but I think that the right thing is that no restore backups from S2k8 to S2k5! - that's it!
October 22, 2009 at 1:46 pm
Dugi (10/22/2009)
Link info is useful, I will try with Export data or everything to script definitions and data...will try and I will see what happening ...I know this fact but that the backup from SQL Server 2008 will not work in SQL Server 2005, but just if you create the DB in SQL Server 2008. Little bit confusing but I think that the right thing is that no restore backups from S2k8 to S2k5! - that's it!
What you are missing is the fact that once a database is attached or restored to SQL Server 2008, then that database has been upgraded to SQL Server 2008 and can no longer be attached or restored to a lower version.
Doesn't matter where the database was created - doesn't matter what version it was created as. Once the database has been upgraded (and again, that is attached or restored) the database is of that version.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 2:07 pm
Yea now everything is clear to me...so good experience if you try to work with both versions of SQL Server. I will try with export / import and scripting !!!
October 23, 2009 at 2:36 am
Ok just for info about this problem that I done everything with export and inserting data to the existing table but first deleting the old data then reseeding values and after that inserting the new values from the exported tables. This was the journey to correct my problem that will not happened again! :w00t:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply