2012年2月24日星期五

Full Backup

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?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" <kaylisse@.yahoo.com> wrote in message
news:ffe01bb8.0411081044.4446a7ab@.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?

没有评论:

发表评论