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

How to recover specific table from sql backup in sap

Posted on Mar 31, 2015 at 05:39 AM 285 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

Microsoft SQL Server
Add comment
10|10000 characters needed characters exceeded

4 Answers

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

    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 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

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

    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 comment
    10|10000 characters needed characters exceeded

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

    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 comment
    10|10000 characters needed characters exceeded

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

    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 comment
    10|10000 characters needed characters exceeded