InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 16:06:31 GMT20http://www.sqlservercentral.com/Forums/Topic1392770-391-1.aspxThank Bhuvnesh! The status is 0.And I checked it back after some hours and it's been backed to normal. just wondering now if the only way to resolve this is wait...VWed, 05 Dec 2012 02:04:06 GMTsqlneshttp://www.sqlservercentral.com/Forums/Topic1392770-391-1.aspx[quote][b]sqlnes (12/4/2012)[/b][hr]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[/quote]check the status of this database in sys.databasesWed, 05 Dec 2012 01:06:43 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1392770-391-1.aspxHi,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!VTue, 04 Dec 2012 20:31:55 GMTsqlnes