Thursday, December 17, 2009

Full backup progress

Here is what happens on a full database backup

1. lock database blocking all transactions

2. place a mark in the tran log

3. release the database lock

4. back up all data pages in the database

5. lock database, mark transaction log, unlock database

6. write all the transactions between the two marks to the full backup file (but they also stay in the log file)

No comments:

Post a Comment