Backup not working ...Error 3241

  • Dugi

    SSCoach

    Points: 17998

    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!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • George M Parker

    SSCertifiable

    Points: 5382

    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:

    http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/32a67469-0636-4ded-923f-2e257f7e68e1

  • Dugi

    SSCoach

    Points: 17998

    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!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Jeffrey Williams

    SSC Guru

    Points: 88593

    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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Dugi

    SSCoach

    Points: 17998

    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 !!!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Dugi

    SSCoach

    Points: 17998

    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:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply