Post reply

Upgrade 2000 DB to 2008

  • October 15, 2009 at 8:06 am

    #215575

    I'm looking @ upgrading our 774 GB DB from 2000 to 2008. There won't be any new hardware so I won't be able to upgrade a copy on a different server.

    Any suggestions will be appreciated!

    Thanks, Tina

  • October 15, 2009 at 8:12 am

    #1066284

    HI Jonest

    Any suggestions will be appreciated!

    What suggestions do you expect to hear from us?

    Tal Ben Yosef
    www.TalBenYosef.com
    (visit my LinkedIn profile)

  • October 15, 2009 at 8:15 am

    #1066286

    My suggestion would be to do a lot of testing before you try this in production, if you do not have another server you can always install a virtual machine and use this for testing.

  • October 15, 2009 at 8:19 am

    #1066289

    What's the question?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 15, 2009 at 8:21 am

    #1066293

    Tina,

    download the upgrade advisor and check out the 2000 installation.

    Backout is an uninstall\reinstall SQL2000 so make sure you are in a position to do that. backup up ALL databases before you start. Extract details on your installation (sp_configure, keep last errorlog). I would recommend taking flat file copies of the SQL2000 system database files before you start to simplify any backout to SQL2000.

    If you have DTS install the backward compatibility tools as well so you can still edit DTS packages until you can migrate them to SSIS (search technet for SQL 2008 feature pack)

    allow plenty of time, you will need to reindex the database to get good performance after the upgrade.

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

  • October 15, 2009 at 8:22 am

    #1066294

    AAAaaaaaaaaaaaaaaaaaaaargh!

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

  • October 15, 2009 at 8:30 am

    #1066297

    george sibbald-364359 (10/15/2009)

    AAAaaaaaaaaaaaaaaaaaaaargh!

    Was that the answer, or did you have a caffeine free moment.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 15, 2009 at 8:32 am

    #1066301

    Thank you, you've given me a lot to check into.

  • October 15, 2009 at 8:40 am

    #1066307

    I was hoping to find someone who has upgraded a large DB from 2000 to 2008 & wouldn't mind sharing any helpful tips.

    Sorry for the vagueness of my post.

  • October 15, 2009 at 8:47 am

    #1066315

    Silverfox (10/15/2009)

    george sibbald-364359 (10/15/2009)

    AAAaaaaaaaaaaaaaaaaaaaargh!

    Was that the answer, or did you have a caffeine free moment.

    Gail Knows. She keeps pre-posting me. I think she's playing with my mind. 🙂

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

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

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