Home Forums SQL Server 2008 SQL Server 2008 - General CHECKPOINT block ALTER DATABASE RE: CHECKPOINT block ALTER DATABASE

  • December 5, 2012 at 1:06 am

    #1565596

    sqlnes (12/4/2012)

    Hi,

    I tried to modify the size of autogrowth for one of the data files in my database. However, it took a long time and could not be done. After checked active sessions I found it's blocked by CHECKPOINT session. My SQL Server was restarted around 15 hours ago and i guess the CHECKPOINT has been active since then. Is the only option I have right now is to wait for it to complete until I could apply the ALTER DATABASE comment?

    Thanks!

    V

    check the status of this database in sys.databases

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