Recently after a VMware recovery of a database server i found my database in the "Recovery Pending" state. In this state nobody could connect to the db - which renders it pretty useless. After some googling i found here the simple and working solution.
Start the MSSQL Server Management Studio, connect to the server and run the following statements
ALTER DATABASE [DB_Name] SET SINGLE_USER WITH NO_WAIT;
ALTER DATABASE [DB_Name] SET EMERGENCY;
DBCC checkdb ([DB_Name], REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE [DB_Name] SET online;
ALTER DATABASE [DB_Name] SET Multi_USER WITH NO_WAIT;
ALTER DATABASE [DB_Name] SET EMERGENCY;
DBCC checkdb ([DB_Name], REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE [DB_Name] SET online;
ALTER DATABASE [DB_Name] SET Multi_USER WITH NO_WAIT;
After that it was possible to bring the database online again and it worked like a charm.
![[RSS]](/resources/icons/silk/bullet_feed.png){kind=icon}
