dwain.c (2/26/2014)
andrew gothard (2/26/2014)
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.
FTFY 😀
I stand corrected sir!
I shall now correct myself and add "Documented". That's a biggie too. The best strategy in the world is no use if no-one knows what it is.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.