log backup fails a few times a day
I have a server where the log backup that runs every hour fails a few times a day. Unusally when I get the email notification I fire the job off again and it works fine so I haven't spent any time investigating. Today I tried running the job serveral times and it kept failing. I looked in management studio activity monitor and noticed the Checkpoint was blocking. I ran checkpoint by itself and it took 6:48 minutes to complete. After this completed I was able to run the backup job successfully. I'm running sql backup 5.0. The backup runs checkpoint before it starts so, what is the wait time for log backup and how can I increase it? I'm not sure the significance of long wait times for checkpoint. I know you can pass a variable to increase the resources it will use to speed up the process. This is a SQL2005 SP2 standard edition 32 bit server.
0 · Share on Twitter