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