October 3, 2013 at 2:07 am
Checkpoint and log backup both have feature to "truncate the log".
Checkpoint primarily handles by sql server internally but backup log doesnt.
Checkpoint flushes the dirty pages to disk.
ANy other differences ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 3, 2013 at 2:11 am
I think the main difference is that a log backup actually does a backup?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 2:59 am
I think the question would be more appropriately phrased 'any other similarities?', because other than that they can truncate the log (checkpoint in simple, log backup in other recovery models) there are no similarities between the two.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply