Restore Data from Transaction Log

How to Restore Database

Steps:

1.           Logon into SQL Server Management Studio.

2.           Right click on databases and Click on “Restore Database…”.

3.           Write Database Name “PromotionalExpenseDB” in “To Database” text box and then add latest Full database by selecting from “From device”. 

4.           Select database to restore.

 

 

5.           Select “Options” from select page pane.

 

6.           Select “RESTORE WITH NORECOVERY” through Recovery state radio button.

7.           The message appears.

 

8.           Now, restore latest differential database by right click on the “database” .

 

9.           Select Task --> Select Restore --> Database.

10.       Then follow steps 3-7.

11.       Then restore transaction logs which were backed up after the latest differential backup till last transaction log by following steps 8-10.

12.       For the last transaction log choose “RESTORE WITH RECOVERY’’ steps 5.

13.       The entire database restore process will be complete successfully.