Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

• Sushant Yadav

  SSCrazy

  Points: 2780

  More actions

  May 3, 2013 at 3:52 am

  #394715

  I stopped the backup job which was running for arround 2 days,

  now it is showing in rollback state since last 1 day,

  And rollback process is blocking the other processes,

  I am getting following error when trying to access the database through other server.

  Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  May 3, 2013 at 5:09 am

  #1612144

  What is the SPID the rollback in running under?

  What is the output of sp_lock spid ?