I had read somewhere (can not remember where) that MS SQL 6.5 was a snapshot
of the database at the start time of the backup, while SQL 7 and 2000 are a
snapshot of the database at the end time of the database. In each case, the
backup process is watching what is going on in the log file.
Oscar...
"DBA" <ka******@yahoo.com> wrote in message
news:ff**************************@posting.google.c om...
I start a full backup on a database at 5pm. The backup job takes 3
hours to complete. While the backup job is running, someone inserts
records to the db. Will the backup include the new records? Or in
other words, are the contents of a SQL Server backup a snapshot of the
database at the start time of the backup?