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.