October 29, 2008 at 6:43 am
Are SQL 2000 (and SQL 2005) CHECKPOINTS logged anywhere?
I need to determine whether or not my OSQL invoked CHECKPOINTS are executing. The CHECKPOINT syntax runs fine in E/M (on SQL 2000) and M/S (on SQL 2005) but I don't see any logged info indicating success or failure of the CHECKPOINT. I checked the SQL LOGs, Event Viewer, No info posted during the time of the checkpoint.
My syntax looks like this:
USE myDB1; CHECKPOINT; USE myDB2; CHECKPOINT; USE myDB3; CHECKPOINT;
October 29, 2008 at 7:16 am
No they are not logged. May I ask why you are manually setting checkpoints? The Database Engine does this automatically to reduce the recovery time needed on restart.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 29, 2008 at 7:20 am
Jack - EMC recommended we issue CHECKPOINTs to help resolve an EMC Timefinder Freeze/Thaw/Backup (clone) failure we're intermittently encountering on our symmetrix SAN which retains our SQL Server 2000/2005 files.
October 29, 2008 at 7:31 am
Ahhh, thanks for letting me know. I wonder if they have looked at changing (reducing) the recovery interval on the SQL Server so the DB Engine issues CHECKPOINTS more frequently to fix this issue?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 29, 2008 at 11:38 am
Enable trace flag 3502 which tracks checkpointing of databases in errorlog and see if that helps. There will be flood of messages as its at server level.
MJ
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply