Post reply

Upgrade from SQL Server 7.0 to SQL Server 2008 R2

  • October 10, 2013 at 2:05 pm

    #284490

    We would like to do SQL Server 7.0 to SQL Server 2008 R2.

    What is best suitable method for upgrading the SQL 7.0 to SQL Server 2008R2

  • October 10, 2013 at 2:08 pm

    #1657723

    You won't be able to do it in one go. You'll need to restore the database to SQL 2000 or 2005 first, then back it up and restore to SQL 2008. That's just the start.

    Run DBCC CheckCatalog and DBCC CheckDB before you start, don't upgrade if there's problems. Run the 2008 upgrade adviser (if it will run against a SQL 7 database) and fix any problems it identifies

    Those two alone should keep you busy a while.

    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 10, 2013 at 2:08 pm

    #1657724

    I don't think you can skip that many versions in one step.

    You might need to upgrade to SQL 2005 first, and then to 2008R2.

    edit: it seems Gail can type faster 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

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