backup and restore particular application

[Former Member]

Hello Team,

We have customer where Multiple databases(ECC , XI , Portal , BW) is install in one instance (sql server 2008)

Now the customer want ECC to move on cloud with sql server 2012 .I have a below query

1) How to backup and restore particular application like ECC as it is running in one instance

2) If backup/Restore is possible can we do direct restore to mssql server 2012

3) As the ECC database size is approx 4 TB , What is the strategy need to follow to reduce downtime

Need you expert advice.

Regards

Rableen

[Sriram2009]

Hi Rableen.

1) How to backup and restore particular application like ECC as it is running in one instance

In MS Sql MMC you can find the each instance having independent database(DB data & Log files).in that you have to find the ECC. take the backup and restore the DB in Cloud. follow the System copy guide as mention by Luis.

Refer the link System copy guide based on your SAP Version - https://cp.hana.ondemand.com/dps/d/preview/ec5624d5073d4c949b42bf284742748d/1.0/en-US/frameset.htm

2) If backup/Restore is possible can we do direct restore to Ms SQL server 2012.

Yes its possible based on your SAP version. and follow the SAP note as mention by Luis.

3) As the ECC database size is approx 4 TB , What is the strategy need to follow to reduce downtime.

In MS Sql you can do detach the DB and copy the DB, Log files to target system and then attach the same, before that take the full backup and clear the transaction log, it will reduce the downtime.

Regards

Sriram

[luisdarui]

Hi Rableen,

In regards of your questions:

1) Backup/Restore, Detach/Attach or Export with SAP Tools (SWPM) then Import in the target.

Basically you have to follow the system copy guide. Check them at https://support.sap.com/sltoolset

2) Yes, but you have to meet the minimum SAP NetWeaver SPS prerequisites before copying the databas. See SAP Note 1651862.

3) Test, test and retest. You should test it at first to "learn" the procedure and know how much time it will take, revise each step to ensure you have no gaps or room for improvement that would help you with the downtime. Check with the OS/DB migration certified consultants and other sysadmin/cloud consultants, they absolutely have tools and guidance on how to perform such migrations with TB databases within an acceptable time.