SQL Server UPGRADATION

  • Hi All,

    we are going to upgrade our SQL Server 2000 to SQL Server 2005.

    SQL Server 2000 is a 64-Bit, if we install SQL Server 2005 32-bit version will upgradation go smoothly ?

    We have already done this one on one of the Staging servers but dont know whether it is 32-bit or 64-Bit version. But we have upgraded with 32-Bit SQL SERVER 2005 and it ran smoothly.

    Please help me in this ASAP.

    Thanks in Advance.

    Thank You.

    Regards,
    Raghavender Chavva

  • Raghavender (1/16/2009)


    Hi All,

    we are going to upgrade our SQL Server 2000 to SQL Server 2005.

    SQL Server 2000 is a 64-Bit, if we install SQL Server 2005 32-bit version will upgradation go smoothly ?

    We have already done this one on one of the Staging servers but dont know whether it is 32-bit or 64-Bit version. But we have upgraded with 32-Bit SQL SERVER 2005 and it ran smoothly.

    Please help me in this ASAP.

    Thanks in Advance.

    Please run sql server upgradation advisor on existing database server..

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • There is no 64bit edition of SQL 2000 (unless you are running on Itanium, in which case you would be also using the Itanium version of SQL 2005).

    Are you perhaps running SQL 2000 on a 64bit version of the operating system?

    As Paresh suggested, run the upgrade adviser, I would also check your versioning.



    Shamless self promotion - read my blog http://sirsql.net

  • Thank you all for your feed back. Yes, the operating system is on 64-Bit and I too got the my answer.

    Thanks once again.

    Thank You.

    Regards,
    Raghavender Chavva

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

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