Moving from SQL server 2005 to SQL server 2008 ... for a MS/SQL newbie.

[Muadib]

Hello,

I am in charge of moving an existing SAP NW BI (SPS20) from a MS SQL Server 2005 database on Windows Server 2003 (x864/64 bit) Platform to a MS SQL Server 2008 database/Windows Server 2008 Platform (x64/64 bit).

The SID of the SAP system will remain the same.

The thing is that I have always worrked so far on Oracle/Unix environements, windows/MSSQL is an entire new world for me,

so I am quite worried.

I have read many sap notes/installation guides/forum posts regarding this operation, I will describe here my understanding

of the techinical operations that I will need to perfrom.

Could you correct me if I am wrong, as well as give me your comments ?

1/ I will need to perform an SQL server database copy within a homogeneous system copy.

2/First ,I'll have to install on the target environnement the SQL server 2008 database. I'll have to install the SQL Server Database Software with SQL4SAP (no need to install the database server software manually, right ?). Afterwards, I'll install on the target environnent, SAP Netweaver 7.0 SR3 with a modified Instalaltion Master DVD.

3/ On the source environement, I'll perfrom a database backup of the SQL Server 2005 system and restore the database on the target environement. since I choose to perfrom a restore of the database , there is no need to follow all the steps described in sap note 151603 :determine the file structure of the source database, create the directory structure for the target database, etc ...

4/ Once the restoration is finished, I use SAPINST and finish the homogeneous copy : >additional sofware->system copy>target system->central system --> Based on AS Abap --central installation

Your comments are welcome.

Thank you for your attention

Best Regards.

Raoul

[Former Member]

Also, I have a short write-up here that may help with the process:

http://joeybear23.blogspot.com/2010/10/sap-system-copy-procedure.html

Obviously, this is for a Quality System refresh, but the steps are the same, minus renaming the SID.

[Former Member]

Hi Raoul Shiro,

With referrence to your Bi installation described in this Post, we are also performing the BI installation with same SAP BI 7.0 SR3 release Win2008 / DB2008 and same OS and database, and also from another existing BI system with Win2003/DB2005.

I believe you have perfromed Database restore onto the new MSSQL 2008 Database from the old BI system (MSSQL 2005)

Now as we are planning to performing the same activity as per your post described. Before we go in I would like to request you to share your learnings in performing the activity. What challenges you have faced, any suggestions from you?

Thanks in advance for sharing the information.

Regards

Ajay