CHECKPOINT block ALTER DATABASE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » CHECKPOINT block ALTER DATABASE

CHECKPOINT block ALTER DATABASE

Rate Topic

Display Mode

Topic Options

Author

Message

sqlnes

Posted Tuesday, December 04, 2012 8:31 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 25, 2013 8:46 PM
Points: 19, Visits: 230

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

Post #1392770

Bhuvnesh

Posted Wednesday, December 05, 2012 1:06 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

sqlnes (12/4/2012)

check the status of this database in sys.databases

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1392824

sqlnes

Posted Wednesday, December 05, 2012 2:04 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 25, 2013 8:46 PM
Points: 19, Visits: 230

Thank 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...

V

Post #1392840

« Prev Topic | Next Topic »

Permissions