SQL Server – Transaction Log Backups

backuprestoresql servertransactiontransaction-log

I am working on backup+recovery scenario and I came across a situation where I could not figure out how I would have to deal with it.

We have couple databases where sometimes there may not be any activity for 20 to 30 minutes. We have Transaction Log Backup setup every 15 minutes.

My questions are:

Would there by any TR Log Backups for that time period?

What would happen if I happen to restore those transaction log ?

I'm sorry, I tried looking for answer on different places and books, but could not find it. If someone can please help me out.

Thank you in advance.

Best Answer

would there by any TR Log Backups for that time period?

If there is no activity at all, there would be not transactions. But there is no harm in taking that backup as a part of your backup schedule (which is every 15 mins).

It will look like - 

/*Processed 0 pages for database 'logbackup_test', file 'logbackup_test_log' on file 1.
100 percent processed.
BACKUP LOG successfully processed 0 pages in 0.072 seconds (0.000 MB/sec).
*/

what would happen if I happen to restore those transaction log ?

You will be able to restore them in sequence or you can possibly skip it as well- if there is NO gap in the Log Sequence Numbers of the log backups..

Related Question