Post reply

Checklist for AFTER upgrade from 2000 to 2005

  • September 4, 2008 at 1:14 pm

    #131158

    Hello all,

    I updated my db from 2000 to 2005, and have set the compatibility to 90 (understanding that sometimes its best to leave it at 80).

    But now what, besides testing application connections, etc. ?

    I've heard that one should recreate full text indexes...can someone tell me how or if its necessary, please ?

    I also heard that I need to update the statistics on the database....how do I do that ?

    I have 'Auto update statistics' turned to 'true'...anything else I need to do ?

    Any other good practises ?

    Thank you

  • September 4, 2008 at 2:04 pm

    #867407

    None of these are necessary, but can't hurt and help to ensure all is well ...

    DBCC CHECKDB (DBName)

    Rebuild Indexes (don't know much about FTI, sorry) - this should also update the stats

    Check errorlog (sp_readerrorlog)

    Check event viewer

    Apply SP2

  • September 4, 2008 at 2:12 pm

    #867411

    thanks Adam...about SP2...do I need to be concerned with that for users that only have 2005 Client tools (not database) on their machines ?

  • September 4, 2008 at 2:15 pm

    #867416

    koln (9/4/2008)

    thanks Adam...about SP2...do I need to be concerned with that for users that only have 2005 Client tools (not database) on their machines ?

    Nope. Not that I've ever experienced a single problem in 2000 or 2005 when applying service packs, obviously it's always best to test in a QA environment to ensure your applications continue to work properly before deploying to your production environment.

  • September 4, 2008 at 3:21 pm

    #867470

    Before running DBCC CHECKDB, run DBCC UPDATEUSAGE.

    This is because SQL Server 2000 can have some incorrect counts, which results in warning messages being produced by 2005 in CHECKDB.


    Check Your SQL Servers Quickly and Easily
    www.sqlcopilot.com

  • September 4, 2008 at 3:43 pm

    #867480

    Article on http://www.sqlservercentral.com/articles/Administration/2987/ says you need to create fulltext indexes again.

    MJ

  • September 5, 2008 at 5:56 am

    #867683

    update statistics by:

    use {databasename}

    exec sp_updatestats

    Wilfred
    The best things in life are the simple things

  • September 5, 2008 at 9:22 am

    #867865

    Excellent short, to the point, answer my question response Wilfred....thank you

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

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