Internal Checkpoint Issue

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  June 11, 2014 at 3:07 am

  #289792

  One of the Background spid is showing as a CHECKPOINT status and never clears out. Due to this,i cant able to RESTORE the database (routined job), it cant take exclusive Lock.

  Below is the only high resource statement I can see running in background.

  13 BACKGROUND sauserdatbase CHECKPOINT 4245251024210/06/2014 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 restore?

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  June 11, 2014 at 3:29 am

  #1720687

  Have you tried

  use master

  go

  alter database yourdatabasename

  set restricted_user with rollback immediate

  then trying your restore?