[dba-SQLServer] From a reader

Without drawing a diagram, he loses me in para 2. Any help?

Susan H.


Could you be kind enough to clarify a BIG question I have about Transaction 
Log application?  If I have a database in full recovery model (DB1) and I do 
a full backup I can then restore this backup on a different server 
(DB1_copy) and apply the transaction log backups from DB1 to DB1_copy. I 
should have no problem and my tests confirm this.



But let's say I take a full backup of DB1  on Sunday.  T-log backups of DB1 
continue on an hourly basis.  Monday morning, I restore DB1 on a different 
server as DB1_copy with NORECOVERY and start applying all T-log backups WITH 
NORECOVERY to DB1_copy that have been taken from DB1. Monday night, I take a 
full backup of DB1 but don't restore it to DB1_copy, instead I apply (or try 
to apply) the subsequent T-log backups of DB1 since Monday's full backup to 
DB1_copy.  Based on my tests this doesn't work. Below is the SQL Server 
message.  Does every full backup reset something internally ?



Thanks



David Agnew

305.905.6312



SQL Server message.

Server: Msg 4326, Level 16, State 1, Line 1

The log in this backup set terminates at LSN 21000000025000001, which is too 
early to apply to the database. A more recent log backup that includes LSN 
21000000040500001 can be restored.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.