Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2003-02-19 : 04:42:48
|
| I need more informations about what SQL SERVER is doing during online backup. I find only this:1.Issues a checkpoint on the database and records the log sequence number (LSN) of the oldest active transaction log record. 2.Writes all pages to the backup medium by reading the disks directly (bypassing the data cache). 3.Writes all transaction log records from the LSN captured in step 1 through the end of the log. Does this mean that during backup SQL SERVER don't issues a checkpoint, so data on disk is consistent (like this works ORACLE)??, and all changes stays in RAM??? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-19 : 07:40:18
|
| No. Your last statement completely contradicts the three points you posted. It DOES issues a checkpoint and reads ALL of the transactions DIRECTLY FROM DISK, so they've already been committed. |
 |
|
|
|
|
|
Backup proccess