Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CHECKPOINT block ALTER DATABASE Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2012 8:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 3:57 AM
Points: 32, Visits: 301
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
Posted Wednesday, December 5, 2012 1:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 2,837, Visits: 3,957
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
Post #1392824
Posted Wednesday, December 5, 2012 2:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 3:57 AM
Points: 32, Visits: 301
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 »

Add to briefcase

Permissions Expand / Collapse