SQL Server Performance

checkpoint errors -restarting sql server services

Discussion in 'General DBA Questions' started by ananda, May 13, 2009.

  1. ananda New Member

    Hi,
    I am using sql server 2000 & service pack 3
    when restarting sql server services the folowing erros found in SQL error Log.
    spid11 Recovery is checkpointing database 'BRIBS' (7)
    spid11 1 transactions rolled back in database 'BRIBS' (7).

    Can any one give me sloution for the same.
    Thanks
  2. MohammedU New Member

    These are not errors...
    SQL server is writing what is doing when you restart...
    Whenever you restart sql does the auto recovery to keep db in consistenct state...so it will roll forward committed transactions and will roll back uncommitted transactions...

Share This Page