database options

  • Hi All,

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

  • They should be.

  • 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.

  • thanks for checking Andrew - I have done that

  • 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

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

  • 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.

  • 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