Posted by flobroed@googlemail.com on 09/25/06 17:45

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

• Next in forum: Re: what should i do when i want to save a select resultset,but not in a new table,in memory is the best?
• Prev in forum: Re: Date comparison problem
• Thread view: SQL Server 2000 Transaction Log Backup Question

[Reply to this message]