Fix Recovery Pending State in SQL Server Database

Fix Recovery Pending State in SQL Server Database

https://mstechtalk.com/fix-recovery-pending-state-sql-server/


ALTER DATABASE [DVSB] SET EMERGENCY;

GO

ALTER DATABASE [DVSB] set single_user

GO

DBCC CHECKDB ([DVSB], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;

GO

ALTER DATABASE [DVSB] set multi_user

GO

Comments

Popular posts from this blog

Extracting and using a modified VMWare Player BIOS or UEFI firmware

OpenVBX v1.2.21 r79 - Twilio JS Version 1.5.2

SonicWall firmware Sonic OS 5.9.1.13