If you are a Database Administrator, seeing a database stuck in status is a heart-stopping moment. Your application is down, users are complaining, and the database is inaccessible.

ALTER DATABASE [YourDatabaseName] SET MULTI_USER; ALTER DATABASE [YourDatabaseName] SET ONLINE;

This puts the database in read-only mode and marks it for repair.

Personal tools
Namespaces
Variants
Actions

Database Recovery Pending ✦ [TRUSTED]

If you are a Database Administrator, seeing a database stuck in status is a heart-stopping moment. Your application is down, users are complaining, and the database is inaccessible.

ALTER DATABASE [YourDatabaseName] SET MULTI_USER; ALTER DATABASE [YourDatabaseName] SET ONLINE; database recovery pending

This puts the database in read-only mode and marks it for repair. If you are a Database Administrator, seeing a