Skip to Content

Restore Table from Backup File

Dear Experts,

Unfortunately we lost some data records in one table, but we have backup files as a result of full backup process. My questions is "can we restore data records from backup file only for one table?" If can, how to do that?

Tx & best regards,

Heydarul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 18, 2009 at 04:49 AM

    no, not possible to restore one table from full backup

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2009 at 05:19 AM

    If u know whn ur data lost then u can do through timebased incomplte recovery.

    otherway restore full database to a dummy machine and

    take export single table from dummy machine then import to origional machine.

    Note : Not suggest to production environment.

    Surendra Jain

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2009 at 07:16 AM

    Hi..

    The best way to get data in the table back to do the tablespace recovery upto that time when you lost data. but it will delete all data which has been stored after you lost data. ( Not suggested to do in production).

    For storing a sinsle table,

    You can install a separate database, restore and recover it and get the table data exported form temporary created database and import in your SAP database.

    Regards,

    Abhimanyu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Heydarul Humam

      You do not need to restore the complete database.

      You could follow the procedure indicated on the SAP Note 594601 "Restore table in minimal copy of current database".

      Keep in mind the procedure mentioned in the note can (probably WILL) leave your system in an inconsistent state as you are introducing "manualy" data in a table that should be on other tables.

      You must open a message at SAP on the application area you want to restore the data. That way they can check for logical inconsistencies, or tell you how to do it.

  • avatar image
    Former Member
    May 18, 2009 at 06:54 AM

    How did you "lost some records"?

    Did you "lost" records from an SAP table or from a customer (Z/Y) table?

    Are you sure you want to "recover" only those records? doing so can create logical inconsistency in your database. Have you checked so?

    Add comment
    10|10000 characters needed characters exceeded