469,644 Members | 1,965 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,644 developers. It's quick & easy.

SQL Server 2000 Transaction Log Backup Question

Hi,

I've a question regarding the transaction-log backup on SQL-Server
2000. We have implemented a low cost replication. Every evening we make
a full backup and beginning at 7 to 18 we make transaction-log backups
which are restore (no recovery) to the "standby-server". The full
backups are restored every evening.

Today i noticed something strange. Yesterday the last transaction log
was made at 19 and afterwards applied to the standby server. At 20:30 a
full backup was made, but NOT copied to the standby server and hence
not aplied there. Starting at 7 this morning the first transactionlog
was copied and successfully restored by the standby-server. To my
surprise.
Because yesterdays full backup wasen't restored at the standby server,
just the transaction logs.
I thought, if you make a full backup SQL Server "resets" or "destroys"
the log-chain. Imagine the following timeline.

x-2 -- x-1 -- x -- x+1 -- x+2,

where x represents a full backup and the other ones are transactionlog
backups. So you can restore x+1 WITHOUT restoring the full backup at x
if you have succesfully restored x-1 with no recovery?!

Thanks in advance.

Bye Florian

Sep 25 '06 #1
0 1467

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by Thue Tuxen Sørensen | last post: by
6 posts views Thread by Martin Meyer im Hagen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.