June 27, 2012 at 9:59 am
Have anyone encountered this before?
One of the Background spid is showing as a CHECKPOINT status and never clears out. Due to this, our backups (Full, Differential, logs) are hanged in between and never completed. If we try to run a kill statements against our backups spid, that kill statement never completes and Halt in between.
Below is the only high resource statement I can see running in background.
13 BACKGROUND sa . .userdatbase CHECKPOINT 4245251024206/10 19:45:24
Can anyone suggest me, how to clear this background spid of checkpoint without restarting the SQL Server? or suggest any other way to run our backups?
Thanks,
AB
June 27, 2012 at 1:19 pm
Anyone??
June 27, 2012 at 1:24 pm
have you tried issuing a manual checkpoint to that database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 2:03 pm
Yes I did; Manual checkpoint completed successfully within less than a second. That background process still there. Lets see if SQL Server clears it out by tomorrow or so.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply