Sql 2000 to sql 2008 upgrade..!!

[former_member823277]

Dear Experts,

I want to upgrade sql 2000 to sql 2008R2.

Is their any bottle necks are there and procedure...is it easy or complex.

Attach/Detatch or backup/restore will work..??

Pls advice...!!

[former_member184473]

Hello,

You can get further information with the SQL Server 2008 upgrade guide:

http://service.sap.com/instguides

> Database Upgrades

> MS SQL Server

> Upgrade to and Installation of SQL Server 2008 (R2)

Also, the following notes:

1152240 - Setting Up Microsoft SQL Server 2008 (R2)

1076022 - Release planning for Microsoft SQL Server 2008 (R2)

1144459 - SAP Installation Media and SQL4SAP for SQL Server 2008 (R2)

1237682 - Configuration Parameters for SQL Server 2008

Regards,

Eduardo Rezende

[Former Member]

If you are simply looking at the database engine, you can do an in-place upgrade from SQL Server 2000 to SQL Server 2008. You need to be on SQL Server 2000 Service Pack 4 to do an in-place upgrade. I would not, however recommend doing an in-place upgrade because of the risks associated with failed upgrade. Plan your upgrade strategy well to avoid extended downtime. You could spin up a new server, install SQL Server 2008 and do a backup/restore of the databases or configure log shipping to minimize downtime. Once the databases have been moved to the SQL Server 2008 instance, do not forget to update the statistics immediately.

Plus, since you're still on SQL Server 2000, would you not be upgrading to Windows Server 2008 for your operating system?

[jairo_pedroza]

Hello m s,

You should use Upgrade Procedure or export/import.

Download Tools and files from http://service.sap.com/platforms    > Microsoft > SQL Server

Attach/Detach or Backup/respore you will use to SAP Homogeneos System Copy

Regards,

Jairo Pedroza