on 10-08-2013 11:54 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.