Skip to Content
author's profile photo Former Member
Former Member

Recover testing

Hi Friends,

We are in plan of testing the backup and restore of our database. Our environment is windows 2008, MS SQL 2008, and ECC6.0.

We have offline backup of our SAP system.

Now Please tell me the procedure to testing of my backup ( ie restore of my DB).

For that the steps:

1. Download the installation master and Kernel

2. Perform the system copy i.e target system installation

3. Follow the back/restore procedure

I need to perform the below steps before pre-requites:

1, Do I need to offline and detach the existing DB

2. Do I need to rename the folder as *_Old

3. Do I need to rename the <Drive>: usr as usr_old

Please confirm.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 02, 2012 at 05:41 PM

    Hello Venkat,

    Check the following note for further information:

    151603 - Copying an SQL Server database


    Eduardo Rezende

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 02, 2012 at 05:33 PM

    If you are testing the backup, then all you need is another SQL Server 2008 instance with the same drive specification as the initial system. Then use the restore option in sql server management studio to restore.

    I don;t think you need to install SAP unless you want to perform a homogenous system copy which is not the case as per your email.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.