1-) MSSQL RMOS - How to fix Recovery Pending State in SQL Server Database

kaynak : https://www.stellarinfo.com/blog/fix-sql-database-recovery-pending-state-issue/

ALTER DATABASE [DBName_Yaz] SET EMERGENCY;

GO

ALTER DATABASE [DBName_Yaz] set single_user

GO

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

GO

ALTER DATABASE [DBName_Yaz] set multi_user

GO

EĞER OLMAZSA SATIR SATIR SEÇ ÇALIŞTIR