cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Moving the database

Go to solution
former_member183788
Active Participant

on ‎11-24-2015 9:41 AM

0 Kudos

Dear,

Can we move the already installed sql sap database to a new server and connect to the sap application?

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

luisdarui
Advisor
Advisor
‎11-24-2015 10:31 AM
0 Kudos

Hi Prathish,

Yes you can do this by:

  1. Instal SQL Server on the new server;
  2. Copy the database as per SAP Note 151603.
  3. Run SWPM system Copy option for 'Database Refresh or Move'.

Best Regards,

Luis

Show replies
Show replies
former_member183788
Active Participant
‎11-24-2015 10:49 AM
0 Kudos

Dear Luis,

We did the following:

Source system:

1.Stopped sap in source system.(OS+SAP+DATABASE sql server 2012)

2.Stopped sql server.

3.Detach database.

Target System:

1.Installed sql 2012(No sap application installed)

2.Attach database of source system

3.Running software delivery tool for database copy completion.

4.Got stucked in "Install temporary license" phase.

Error:

<html> <head> </head> <body> <p> An error occurred while processing option <i>Generic Installation Options > MS SQL Server > Database Tools > Database Copy Completion( Last error reported by the step: System call failed. Error 2 (The system cannot find the file specified.

) in execution of system call 'CreateProcessAsUser' with parameter (<token>, NULL, <command line for executable saplicense.exe, NULL, NULL, TRUE, 0x420, NULL, C:/Program Files/sapinst_instdir/GENERIC/MSS/DBTOOLS/MSS/CPY, &StartupInfo, &ProcessInfo), line (649) in file (synxcchapp.cpp), stack trace: iaxxejsctl.cpp: 146: EJS_ControllerImpl::executeScript()

d:\depot\bas\720_rel\bc_720-2_rel\gen\optu\ntamd64\ins\sapinst\impl\src\ejs\iaxxejsbas.hpp: 461: EJS_Base::dispatchFunctionCall()

iaxxejsexp.cpp: 178: EJS_Installer::invokeModuleCall()

iaxxbprocess.cpp: 423: CIaOsProcess::start_impl()

synxcchapp.cpp: 241: CSyChildApplicationImpl::start(false)

synxcchapp.cpp: 265: CSyChildApplicationImpl::doStart()

.)</i>. You can now: </p> <ul> <li> Choose <i>Retry</i> to repeat the current step. </li> <li> Choose <i>Log Files</i> to get more information about the error. </li> <li> Stop the option and continue with it later. </li> </ul> <p> Log files are written to <code>C:\Program Files/sapinst_instdir/GENERIC/MSS/DBTOOLS/MSS/CPY</code>. </p> </body></html>

luisdarui
Advisor
Advisor
‎11-24-2015 2:45 PM
0 Kudos

Hi Prathish,

This option is for systems older than SAP NetWeaver 7.0:

"Use this option only for SAP systems based on SAP NetWeaver '04 (Web AS 6.40) and lower.". This is also documented in SAP Note 683447.

The 'Database Refresh or Move' is under System Copy for your SAP NetWeaver system, ex:

SAP NetWeaver 7.4 Support Release 2

> MS SQL Server > System Copy > Target System > Based on AS ABAP > Database Refresh or Move.

Best Regards,

Luis Darui

Answers (0)

Ask a Question