If ldf got corrupted or Database went into inRercovery.Then steps needs to follow.
Database went into inRercovery
1. Then Wait until database recovery.Ldf got corrupted:
1. Alter database "DB_NAME" SET emergency2. Alter database "DB_NAME" SET single_user
3. DBCC CheckDB("DB_Name",Repair_Allow_Data_Loss).
4. Alter database "DB_NAME" SET Multi_user
Comments
Post a Comment