December 4, 2012 at 8:31 pm
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
December 5, 2012 at 1:06 am
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;-)
December 5, 2012 at 2:04 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply