Restoring a db

Question

Please can someone lay out the steps to a complete Restore of a db and how to apply a tail log for a db in Full recovery mode? Thanks

Answer 1

Hi Sap9955,

Here it will be:

1) Take Tail Log Backup

             http://msdn.microsoft.com/en-us/library/ms179314.aspx

             http://msdn.microsoft.com/en-us/library/dd297499.aspx

2) Restore Database with NO RECOVERY

             http://msdn.microsoft.com/en-us/library/ms177429.aspx

             http://msdn.microsoft.com/en-us/library/ms186858.aspx

3) Restore Transaction Logs with NO RECOVERY

             http://msdn.microsoft.com/en-us/library/ms177446.aspx

             http://msdn.microsoft.com/en-us/library/ms186858.aspx

4) Restore Tail Log Backup (taken in step 1) with Recovery/Stop AT option.

             http://msdn.microsoft.com/en-us/library/ms179314.aspx

HTH

 

---

Regards Gursethi Blog: http://ms-gursethi.blogspot.com/ ++++++++++++++++++++++++++++++++++++ Please mark "Propose As Answer" if my answer helped +++++++++++++++++++

Answer 2

Also read Tibor's article

http://www.karaszi.com/SQLServer/info_minimizing_data_loss.asp

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/