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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 checkpoint

Author  Topic 

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2003-10-22 : 07:59:00
Hi,

what happens during cheeckpointing for simple and full recovery mode.
(This was one of interview questions to me).

Thanx.

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2003-10-22 : 08:04:20
This is explained in the following SQL Server Books Online pages:

CHECKPOINT
Checkpoints and the Active Portion of the Log


--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page
   

- Advertisement -