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

How to recover specific table from sql backup in sap

Posted on Mar 31, 2015 at 05:39 AM 477 Views

Hi Expert,

Due to misconfiguration some table has been corrupted in production server. We have last backup of production server (.bkp).

I want to know is it possible to recover specific table from .BKP backup file to production server instead of doing whole restore.

If possible how to do?

SAP details:

OS : Windows server 2008 r2

Database : MS SQL 2008 r2

SAP: ECC 6.0 Ehp 6

Regards,

Dev

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Gaurav Rana
    Gaurav Rana
    Posted on Mar 31, 2015 at 06:09 AM
    1

    You could also refer link

    http://solutioncenter.apexsql.com/how-to-recover-a-single-table-from-a-sql-server-database-backup/

    but still i suggest you to opt complete restore in case of PRD to avoid any issues.

    Regards,

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

    • S Sriram Former Member
      Apr 01, 2015 at 05:41 AM

      Hi

      If the master data is

      We will loss present master data if we restore whole db backup from previous backup file.

      1. In this case you have to restore the full database from the very good backup, and then check the master data,

      or you have to follow the step 2

      2. As already said by Gaurav, You have to restore the full db in different system and then upload the master data from restore DB to SAP system.

      BR

      SS

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2015 at 06:57 AM
    1

    hi,

    As you want to recover specific table, I would suggest u to perform restoration on a test server(such as SANDBOX).

    Afterwards perform the export of required table then import it on PRD. SQL server comes with a specific export-import tool to achieve the required.

    Regards,

    Akshay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Gaurav Rana
    Gaurav Rana
    Posted on Mar 31, 2015 at 05:57 AM
    0

    Hi,

    is it possible to recover specific table from .BKP backup file to production server instead of doing whole restore.

    Unfortunately no,complete restore would be best option here.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 19, 2016 at 09:15 AM
    0

    Generating Scripts would be a better option to recover specific table from SQL backup. if it fails then you can recover the specific table using any third party SQL recovery tool

    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.