<div>
This means you want to restore more Logs after the restore is finished. While the database is is in restoring state, you can not access it.
</div>


This means you want to restore more Logs after the restore is finished. While the database is is in restoring state, you can not access it.

President

rwheeler23

<div>
Then this is really odd. There are no more log files coming and when I restored the databases they are all on line and ready for use.
</div>


Then this is really odd. There are no more log files coming and when I restored the databases they are all on line and ready for use.

<div>
Thanks both of you for your comments.
</div>


<div>
<div class="content wysiwyg-content">
I went to restore some backups I was given and noticed a logbackup was being created for each restore. This is because the Tail-Log backup before restore checkbox is clicked. What exactly does this do? I see it says the database will be left in the restoring state? Will I be able access this database after restoring? Why would one choose this setting?
</div>
</div>


I went to restore some backups I was given and noticed a logbackup was being created for each restore. This is because the Tail-Log backup before restore checkbox is clicked. What exactly does this do? I see it says the database will be left in the restoring state? Will I be able access this database after restoring? Why would one choose this setting?

What does tail-log backup restore provide?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.