Posts
Few days before I was asked to restore a Table from a backup file? Can you really attain this in sql server 2005? Which is currently under LogShipping.
And then I suggested easiest way to achieve your goal is
1) Restore backup to another server and apply all the transactions logs with NO RECOVERY and last one with RECOVERY until where you want the data to be recovered.
2) STOP LogShipping.
3) Rename the Table which is corrupted or which you want to restore from Backup file.
4) Export the Table from the RESTORED Database which is in another server to the CURRENT production server.
5) Enable Log Shipping.
You should be good to go.
How to Remove LogShipping SSMS
And then I suggested easiest way to achieve your goal is
1) Restore backup to another server and apply all the transactions logs with NO RECOVERY and last one with RECOVERY until where you want the data to be recovered.
2) STOP LogShipping.
3) Rename the Table which is corrupted or which you want to restore from Backup file.
4) Export the Table from the RESTORED Database which is in another server to the CURRENT production server.
5) Enable Log Shipping.
You should be good to go.
How to Remove LogShipping SSMS
No comments:
Post a Comment