472,353 Members | 1,469 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

SQL Server 2000 Transaction Log Backup Question


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
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 1556

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Michael Orlando | last post by:
Any help would be greatly appreciated. My problem is that I need to set up a backup SQL Server 2000 machine which can be used in case of a...
by: Thue Tuxen Sørensen | last post by:
Hi everybody ! I´m maintaining a large intranet (approx 10000 concurrent users) running on one IIS box and one DB box with sqlserver 2000. ...
by: Scott | last post by:
Hello, I'm upgrading from SQL 7 to SQL 2000 on another box. To minimize the downtime I would like to 1) backup my sql 7 database, 2) copy it to...
by: jaekim | last post by:
Hi. I am wondering if it is a good idea to replicate sql server db files using frs. I don't really know how the frs works, so does frs...
by: Martin Meyer im Hagen | last post by:
Hello, I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a server machine. It works almost fine, except the application which...
by: B-BoB | last post by:
Hi All, Would someone give me an explanation on how SQL 2000 server backs up a user database? Is SQL server make a copy of user database first,...
by: John Rajendran | last post by:
Hi there, I need to take a backup with the following scanerio in mind: At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in...
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.