You need to restore the transaction logs and when you ready to do so, you pull up SSMS (SQL Server Management Studio) and see the following:
So now what!
FYI: You cannot restore Transaction logs directly. The Transaction logs depends on the full backup and you will have to restore the full backup first and then the transaction log will be enabled in SSMS.
Requirements Make sure that you have a full backup of the database available Make sure that you have a backup of your transaction logs available
- First Make sure that you have “Recovery Model” set to “Full”. Right Click on the database name , click on properties and you see the following:
- Restore the Full Backup.
- If you go back to SSMS -> Restore and you should see that “transaction log” is no longer grayed out.
- Now you are ready to proceed.