dwain.c (2/26/2014)

---

kenneth.mofokeng (2/26/2014)

---

I don't have clean backup. For some reason, my customer stopped weekly backup and the last backup is several month ago

Since you don't have backup , try to repair the database,

TRY

ALTER DATABASE corrupted_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC ChECKDB ('corrupted_db', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE corrupted_db SET MULTI_USER

CAUTION : There is a high chance of data loss

If you mange to get database online, make sure you implement database backup strategy

Odd. I'd always heard that what's important is to have a FREQUENTLY TESTED recovery strategy.