I have some doubt regarding backup and transaction log. While taking the transaction log, how should we take transaction log backup, should I append every time with the existing one or overwrite it? I want the recovery upto the point of failure.
Say I have taken full backup at 8:00. After that I have done some transactions and taken transaction log backup at 9:00. Again doing some transaction I have taken transaction log backup at 10:00. Transaction log backup has been taken with the option overwrite each time. My question is that If I restore the databse with the full backup and the transaction log backup taken at 10:00, can I see the changes done between 8:00 to 9:00?
How does the transaction log backup keeps information? Does it keep the information from the last transaction log backup?
//All our dreams can come true, if we have the courage to pursue them//