Backup / Restore Test on SQL server. Am I right?

[Former Member]

Hello Colleagues,

We want to execute the following plan in order to test our backup&restore infrastucture. Please couls you point me if I´m leaving something back?

SQL Server 2005 SAP nw2004s based system (I think that the below procedure is valid no matter the system is Abap standalone, JAVA standalone or ABAP+JAVA standalone)

We want to Stop SAP production System HRP in production host.

Detach HRP SQL server in production Host.

Restore from the last full backup on production Host changing the database name to HRPNEW (logical name and filenames)

Attach the new restored files to the SQL Server 2005 (I think that this point is not needed because the restore will leave the database operational if I mark the corresponding option)

Start Sap System and check that everything is OK inside.

Stop SAP system again

detach HRPNEW database

attach HRP original database

Start SAP system and check

FInally delete db files and log files from HRPNEW database.

What do you think?

Thank you very much in advance!

Regards

[Former Member · Accepted solution]

Make sure you also change the SAP profile parameters - SAPDBHOST (RZ10) for database.

[Former Member · Accepted solution]

Thank you for your response.

But, is it needed if I´m restoring in the production server (same host name) the database with another name?

Or you meant to change the database name in anywhere?

Thanks

Regards!

[Former Member · Accepted solution]

Then its OK, but you need to change the database parameter dbs/mss/dbname to new DB name.

I think you have to make sure that your DB SID is not more than 3 characters.