Post reply

SQL 7 database running on a sql 2005 server

  • April 23, 2010 at 2:28 pm

    #144256

    Hello everyone,

    We are planning to restore a SQL 7.0 database (few hundred GBs) on a new SQL 2005 server and set the compatibility level of the database to 7.0.

    Are you aware of any issues that we might be facing? We just want the current application (on a different box) to keep running, i.e. don't care about new functionalities...

    Thank you

  • April 23, 2010 at 2:44 pm

    #1157139

    if you're wise you will setup a test system first and test this thoroughly. The jump from SQL7 to 2005 is huge and the database compatability level will possibly not be a sole saving grace!

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • April 23, 2010 at 2:46 pm

    #1157141

    Perry is correct, but you should be OK in terms of your app with the compat mode. I haven't heard of issues, but I haven't seen many people running in 65 or 70 mode. Most are running 80 mode and it seems to work fine.

    Just remember, once you upgrade it, you can't detach and go back.

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

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