mssql 2005 migrate to mmssql 2008r2

[Former Member]

This is my first post here so bare with me.

I have a sandbox system abab/java running on win server 2008 r2.

This is a Distributed system dabase running on another host with sql 2005.

I would like to migrade the database to a new host sql 2008 r2 with backup/restore.

I´m looking for a guide for this, i know i need to use SWPM but i´m not sure where to find the option for restore/attach database.

Vidar

[former_member193518 · Accepted solution]

You're right Vidar.  It's not very clear at all.

Here's how I did it (although I used backup/restore to minimise downtime):

- Shutdown source SAP system.

- Create the DB directory locations on the target server.

- Ensure that you can logon with the <sid>adm user to the target server.

- Shutdown source DB.

- Detach source DB.

- Copy source DB files to target server.

- Attach source DB to target SQL Server instance (usual method).

- Launch SWPM (you will only need the 7.20 UC and NUC kernel parts, you do not need the SL controllers for this work).

- Go into the SWPM, MS SQL specific section, target DB and select post-system copy.

- The SWPM will run some checks, re-name the schema if it needs to (you don't need it), run some ABAP reports.

- At the end of the SWPM process, you continue with the post-system copy steps from the standard SAP document.

Easy.

Message was edited by: Darryl Griffiths, more specific text.

[Former Member · Accepted solution]

This did work the , i´m now running on sql 2008 r2 on a new database server.

I have a problem with stms the job try´s to connect to the old server how do I change that ?

[former_member193518 · Accepted solution]

Hi Vioar,

Glad you've got it all working.

When you say "job" do you mean background job (visible in SM37) ?

If you do, you need to search for background jobs that are configured to run on a specific application server by checking the settings of background jobs in table TBTCP using fields XPGTGTSYS and XPGRFCDEST.

You may find that some of the jobs have been designated to run on the old server.

If you mean TP, then it could be that TP is picking up an environment variable from somewhere, which tells it the DB hostname.

Darryl

[Former Member]

Hi

I woulde like to know the steps  after the database is in place , what are the steps to configure the system so it knows about the new databse host.

[clas_hortien]

Hi,

these steps are performed by the SWPM, there are no additional manual steps to perform.

Regards

Clas

[Former Member]

what I found in the swpm was "

    You do not need to perform this step if you use database-specific backup /

    restore methods for export and import.

can you please give me the steps,

[sunny_pahuja2]

Hello,

You can use system copy guide for this. Please download system copy guide from http://service.sap.com/instguides.

Please also refer to SAP note 151603.

Thanks,

Sunny

[Former Member]

I have read these notes but i´m still not sure what the steps are.

[sunny_pahuja2]

All the steps are clearly mentioned in the note and system copy guides. If you have some questions related to particular step then we can guide you.

You can also refer to below link:

http://help.sap.com/saphelp_nwce72/helpdata/en/f2/31adad810c11d288ec0000e8200722/content.htm

Thanks,

Sunny

[Former Member]

Hi

don't seem to find what the steps are for the backup\restore steps