View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 04:41 AM
Louis
 
Posts: n/a
Default checkpoint command and backup log

This is maybe a dumb question but I couldn't find a definitive answer
on BOL.

Looking at my backup script. If I issue a CHECKPOINT, does this truly
force all transaction log entries to the data file? Therefore, making
it unnecessary to BACKUP log (just BACKUP database is needed).

Louis
Reply With Quote