Posted by mcaglar@cs.ucf.edu on 09/21/06 20:30

Hello,

I am using SQL Server 2000 with SP4. I have a database with two full
backups at 4:00 PM and 5:00 PM and a transactional log backup at 5:30
PM. Is there a possible way to do a point in time restore to 4:30 PM,
that is between two full backups?

When I try to use the transactional log backup that is taken at 5:30, I
can never specify a time before 5:00 PM. Is the transaction log
truncated at each full backup? If so, even if you take transactional
log backup every ten minutes, and full backups every once in a while,
there will be some point in time which cannot be recovered to, namely
the time between a transactional log backup and a full backup. Take a
log backup at 4:50, and full backup at 5:00 and you can never recover
to 4:55, can you?

Any insight on the topic will be appreciated,

Regards,

M. Baris Caglar

• Next in forum: Re: Using a trigger to generate an ID value
• Prev in forum: Re: UNION / INTERSECT / EXCEPT in SQL Server 2000
• Thread view: Point in Time Backup (impossible for some points?)

[Reply to this message]