sql 2000 Database upgrade to 2005

[Former Member]

Hello,

Our active SAP system works on MS SQL Server 2000 Databases. Will

there be a trouble if we set up Solution Manager 4.0 directly on MS SQL

Server 2005 whose SQL servers versions are different? Can I learn your

suggestions?

Secondly, we are planning to upgrade SQL Server 2000 system to MS SQL

Server 2005 in 2 weeks. I would be glad if you could advise me any

document about this upgrading process.

Note: All systems are working Windows Server 2003 x64 platform.

Best regards

ismail Karayaka

[Former Member · Accepted solution]

Hi

In regards to your first question - should SolMan be installed on SQL 2005, the answer is yes.

In regards to upgrading from 2000 to 2005 please see this thread.

Please note that last time I checked a 32 bit x64 SQL 2000 instance could not be upgraded to 64 bit x64 SQL 2005 instance. Can someone please confirm?

Also note that you should apply SQL 2005 SP2 - which has been available for about 1 month.

Thanks

N.P.C

[Former Member · Accepted solution]

Hi ,

I am going to upgrade it to 2005, so what do you suggest? Fresh installation over 2005

beside 2000 running and then restoring the data or direct upgrading to 2005?

The data size is 500GB. How time will it require for backup and restoring on 2005?

Also please let me know the steps to follow?

Regards

Prashant

[Former Member · Accepted solution]

Correct - you can not 'upgrade' from 32bit SQL2000 to 64bitSQL2005.

However since hes on windows x64, he can detach the DB uninstall SQL2000, Install SQL2005 64bit version and attach the DB into it. You also need to run/complete the tasks for SMT based on your version.

You need to ensure you have applied the basis patches required for SQL2005 before you start the upgrade process.