Skip to main content
Sign in MENU

How to fix a SQL database in Recovery

MS Info
  1. Write the following SQL Query,
    1. ALTER DATABASE [SQL DB Name] SET EMERGENCY
    2. Refresh the databases to make sure SQL DB Name is in Emergency
  2. Then execute the following three SQL Queries one after the other,
    1. Alter Database [SQL DB Name] SET SINGLE_USER
    2. DBCC CHECKDB([SQL DB Name],REPAIR_ALLOW_DATA_LOSS)WITH ALL_ERRORMSGS;
    3. ALTER DATABASE [SQL DB Name] SET MULTI_USER

Related articles