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.
Best Answer
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.