MS SQL Database Recovery Pending

Posted on by

Microsoft SQL Server Database status Recovery pending

1
2
3
4
5
6
7
8
9
10
11
ALTER DATABASE [DBName] SET EMERGENCY;
GO

ALTER DATABASE [DBName] set single_user
GO

DBCC CHECKDB ([DBName], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;
GO

ALTER DATABASE [DBName] set multi_user
GO