Post reply

database options

  • August 17, 2008 at 6:21 pm

    #211254

    Hi All,

    If I restore a 2000 db to a 2005 instance will the database options be transferred too?

  • August 17, 2008 at 6:29 pm

    #859210

    They should be.

  • August 18, 2008 at 5:31 am

    #859371

    I know you didn't specifically ask, but you may want to look into changing the compatibility level of the database once restored in order to take advantage of all of the new 2005 features.

    Before you attempt this, check that your DB doesn't conatain any new reserved words etc. You can check this by running the SQL 2005 upgrade advisor against the database.

  • August 18, 2008 at 4:45 pm

    #859723

    thanks for checking Andrew - I have done that

  • August 21, 2008 at 7:02 am

    #861212

    make sure, you do a

    dbcc updateusage('{databasename}')

    and a

    sp_updatestats

    on your migrated database

    Wilfred
    The best things in life are the simple things

  • August 25, 2008 at 9:51 pm

    #862889

    thank you - I would not have done that if you didn't tell me 🙂

  • August 28, 2008 at 7:09 am

    #864333

    While its great to ask, really you should test and review. I highly suggest that you have the db options documented, perhaps in a wiki, and after upgrading on a test server, run the comparison.

    The more you are prepared, the less you need it.

  • August 29, 2008 at 1:45 am

    #864862

    Run the SQL 2005 upgrade advisor if you are planning to do an in place upgrade.

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

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