Upgrade advisor

  • I have DB in 2000 mode on 2008 want run Upgrade advisor, before just flipping it to 2008 mode . I tried to run it but not luck says

    SQL Server version: 10.00.2710 is not supported by this release of Upgrade Advisor, only SQL2000 or SQL2005 is supported.

    any ideas?

    Thanks

  • Upgrade advisor will not advise for changing the compatiability mode of databases, after upgrade. If you read the error message, it says that this version of Upgrade Advisor cannot be run SQL 2008.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • correct....I was just looking for some suggestions or work arounds!!

    looks like I will have to do a backup/restore on dev and test it in 2008 mode.

  • Yes, that looks like a better option to me.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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