SQL Server “IN RECOVERING” State

Quickly Solutions to solving.

1.     Stop the service (MSSQLSERVER);

2.     Rename or delete the Database and Log files (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data...) or wherever you have the files;

3.     Start the service (MSSQLSERVER);

4.     Delete the database with problem;

5.     Restore the database again.

DETACH TO CLEAN CATALOG IF SQL SERVER DONT WORK CORRECTLY

If necessary detach with:

1) Code Snippet

dbcc detachdb('UserData')

2. delete the physical data files