Need help for quality refresh using MS-SQL DB Backup

[Former Member]

Hello Gurus,

I'm new to basis domain and to SCN.

I need to perform a quality data refresh from my ECC production system.

Our Production and Quality environment is as below :

ECC 6.0

SAP Netweaver 7.0

MS SQL 2005

Production db size is 550GB.

The production being a business critical system, we're unable to secure downtime for remote client copy.

Another approach we're considering if we can do it using last online/offline backup of production database.

It would be of immense help to me if somebody can help me with this approach including the post activity steps.

Thanks in advance.

Dhaval

[former_member188883 · Accepted solution]

Hi Dhaval,

You may look out option for restore backup from production and restore the same on QAS.

Refer SAP note

683447

SAP Tools for MS SQL Server

Which shall help you with post restore steps on the database.

Once DB and SAP is up you may perform generic post restore steps like

- STMS re-configuration

- Adjusting profiles

- Executing BDLS

- Importing RFCs and user master ( if exported before the restore)

- Adjusting Partner profiles

- Configuring backup

- Apply SAP license

Above are just a few of them to name. There could be many more as per customer landscape.

Regards,

Deepak Kori