Apart from Replication I don't see any other way to minimise the downtime. Thanks for your response.

Please ignore this topic, I wasn't selecting the right setup file. Dumb! It's working now.

Thanks for your reply. Yes the user is windows authenticated. So if I just grant read-only access on primary it should replicate after the log ship right?

GilaMonster (7/23/2012)

---

If it's suspect (as opposed to just corrupt), it won't return to normal without running CheckDB with repair allow data loss (the only option valid when the DB is...

Perry Whittle (7/23/2012)

---

farushaik (7/23/2012)

---

Msg 5282, Level 16, State 2, Line 1

Table error: Object ID 706101556, index ID 2, partition ID 72057597246242816, alloc unit ID 72057597500653568 (type In-row data), page (38175:9)....

Anthony,

I was following that process. But the database doesn't change to single user mode for some reason.

I think I'll have to go for restoring from the backup ..

Msg 5282, Level 16, State 2, Line 1

Table error: Object ID 706101556, index ID 2, partition ID 72057597246242816, alloc unit ID 72057597500653568 (type In-row data), page (38175:9). The header...

Running it. Will post the results soon.

Anthony, yes I have backup from the night before and also saved the T-log backups.

Unfortunately I don't remember the exact error messages from CHECKDB query. I got something like...

Sorry I posted this in wrong place. This should in 2000.