GilaMonster (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

NO! NO! NO!

Recommending repairing with no idea of what's actually wrong is insane! We don't even know what the errors are, a sensible recommendation cannot be made on no data. When dealing with corrupt databases the extent of the corruption is essential to know before any useful recommendations can be made. To be honest, since CheckDB's throwing errors I suspect repair will not be a option, it'll likely fail as well.

DO NOT attempt a repair at this point.