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 emergency
2. 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

Popular Posts