Post reply

Backward Compatibility

  • May 24, 2012 at 10:36 am

    #256585

    Hi all

    I know that SQL Server is backward compatible - I can restore a 2005 Database into a 2008 instance.

    Is this possible between Service Packs?

    Can I restore a database for a SQL 2008 SP2 instance into a SQL 2008 SP3 instance?

    I recently took a backup of my MSDB database, upgraded the service pack and was not able to restore the database.

    Thanks

  • May 24, 2012 at 10:43 am

    #1492676

    That should be possible. However, the following article says that system DBs can only be restored to the same version.

    http://msdn.microsoft.com/en-US/library/ms190749%28v=sql.100%29.aspx

    It's a little unclear about SPs but from the phrasing I would infer that it does apply to SP as well. What's the error that you got?

  • May 24, 2012 at 10:45 am

    #1492677

    derekr 43208 (5/24/2012)

    Hi all

    I know that SQL Server is backward compatible - I can restore a 2005 Database into a 2008 instance.

    Is this possible between Service Packs?

    Can I restore a database for a SQL 2008 SP2 instance into a SQL 2008 SP3 instance?

    I recently took a backup of my MSDB database, upgraded the service pack and was not able to restore the database.

    Thanks

    Why are you trying to restore your MSDB from one server to another, this system database has information that will relate to the original server instance. If you need objects from one system to another script them

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 24, 2012 at 10:52 am

    #1492682

    Perry Whittle (5/24/2012)

    derekr 43208 (5/24/2012)

    Hi all

    I know that SQL Server is backward compatible - I can restore a 2005 Database into a 2008 instance.

    Is this possible between Service Packs?

    Can I restore a database for a SQL 2008 SP2 instance into a SQL 2008 SP3 instance?

    I recently took a backup of my MSDB database, upgraded the service pack and was not able to restore the database.

    Thanks

    Why are you trying to restore your MSDB from one server to another, this system database has information that will relate to the original server instance. If you need objects from one system to another script them

    I restored MSDB to the same server, I just updated the service pack before restoring it

    So, Backed up MSDB>>Upgraded SP>>Restored MSDB(Failed)

    This was just done as a test, not a production/live machine by any means

    I'm just trying to fish out whether backward compatibility exists between Service Packs

  • May 24, 2012 at 10:56 am

    #1492686

    derekr 43208 (5/24/2012)

    I'm just trying to fish out whether backward compatibility exists between Service Packs

    Try doing it with a user DB. It sounds like system DBs may behave differently.

  • May 24, 2012 at 10:57 am

    #1492688

    cfradenburg (5/24/2012)

    derekr 43208 (5/24/2012)

    I'm just trying to fish out whether backward compatibility exists between Service Packs

    Try doing it with a user DB. It sounds like system DBs may behave differently.

    I think so too

    Will give it a bash

    Thanks

    Derek

  • May 24, 2012 at 12:07 pm

    #1492709

    User dbs will definitely work ok to a later SP.

    Master will definitely NOT work; master MUST be exactly the same version.

    Not sure about msdb, but apparently same rules apply as for master.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • May 24, 2012 at 12:24 pm

    #1492716

    ScottPletcher (5/24/2012)

    User dbs will definitely work ok to a later SP.

    Master will definitely NOT work; master MUST be to the same version.

    Not sure about msdb, but apparently same rules apply as for master.

    Thanks

  • May 25, 2012 at 2:37 am

    #1492996

    Thanks a lot guys - helped a lot!

    Had same difficulties with the database of my site: www.mobilhaj.dk

Viewing 9 posts - 1 through 8 (of 8 total)

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