SQL Server Logical Chains and Transaction Log - Health Check

Question

I help in a rather disaster recovery, and we restored the database backup a few weeks ago, and then restored the transactions from the transaction log backup.

We did this using SQL Server Management Studio - right-click on the database, restore the full backup, leave it in recovery mode, right-click again, restore the transaction log, etc.

Now I am trying to verify that we did not have spaces in our journals. Is it possible to assume that if SQL Server Management Studio allowed me to restore logs without errors, then there were no spaces in the logs (for example, a log chain ))

In other words - can SQL allow me to recover logs if there are spaces? I suppose this will warn me or stop me in this case.

Thanks for any help you can offer ....

We are working on SQL 2005, but I think the rules for log chains are the same in all versions.

Answer 1

According to Microsoft Transaction Log Backups :

, , , , . , , . , , . " ".

:

, , . .

: , , Management Studio , , , . , , , .

( ), , : , 10 ... 7- ( , ) , .

, , " ", .

Answer 2

. SQL , , .