4

I canceled a query which took too long time. After that, the SQL-Server database was locked. After I restarted SQL Server, the mode of my database was "in recovery". Now I can't access my database anymore. If I look at the properties, I get the following error message (I am domain Admin):

Property Size is not available for Database X. This property my not exist for this object, or may not be retrievable due to insufficient access rights.

If I access the views, I will get following Message:

Lock request time out period exceeded

SQL Server Version: SQLServer 2008 R2

Can anyone help me please? This database should be moved to production tomorrow.

ypercubeᵀᴹ
  • 97,895
  • 13
  • 214
  • 305
Alex
  • 43
  • 1
  • 3

1 Answers1

8

If you look in the ERRORLOG file you'll probably see that the database is in the process of rolling commands forward or backward. Once that process is done the database will come back online. All you can do at this point is wait.

DO NOT restart the SQL Server instance again. All you'll do is cause the SQL Server to start this process over again.

However long the query ran for, you can expect the crash recovery process (that's what is running at the moment) to take about that long to complete.

mrdenny
  • 26,988
  • 2
  • 42
  • 81
  • Hi denny, thanks for your answer. You are right, the recovery process is finished right now. Didn´t know that it can take so long. Thanks – Alex Apr 10 '13 at 18:19
  • 1
    Glad it's all finished. Recovery can take a very long time to run. It all depends on how many transactions there are to roll forward and backward and how large those transactions are. I've managed systems before that if the app servers weren't shutdown first, the database could take hours to come back online. Explaining that to management was lots of fun. – mrdenny Apr 10 '13 at 18:22