August 28, 2001 at 4:27 pm
We backup our SQL 6.5 trans logs hourly and the database once daily at midnight.
The restore option shows:
Database .... 8/28/01 2:42AM - 2:42AM
Trans 8/28/01 2:00AM - 2:51AM
Trans 8/28/01 2:51AM - 3:00AM
The first Trans lack starts before, and end after, the dataabse dump. Can this DB be sucessfully restored based on the above info?
Bill
August 28, 2001 at 7:46 pm
If your backup in this scenario completed at 2:42AM, then it would not capture events that committed after the backup completed. So if your huge transaction comitted during the backup, its data would be rolled into the backup.
A great book to back this up is Inside SQL Server. It has a great internals section on backups. Hope this helps!
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy