AW: [Emerald] Corrupt Emerald?

Peter A. Sang ( (no email) )
Thu, 13 Jul 2000 08:52:29 +0200

If you haven't found it in between - there are some techniques how to
recover a db that is in the suspect state and therefore offline. At =
you have to check WHY it was marked suspect (SQL error log), then if
possible correct the fault and try to reset it by resetting the flag. =
procedure ist covered in the SQL Books online, in addition search the =
for 'suspect recover'. Article Q180500 describes a very common =
where a database is marked as suspect, but it depends on your =
If the described procedure (sp_resetstatus) does not help - you do have =
recent backup, don't you????
Good luck!

Mit freundlichem Gruss,

Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * *
* Microsoft Solution Provider - Internet/Intranet Specialist *=20

-----Urspr=FCngliche Nachricht-----
Von: Rafael Gomez []
Gesendet: Donnerstag, 13. Juli 2000 00:02
An: Emerald
Betreff: [Emerald] Corrupt Emerald?

Anybody of you knows what to do when the Emerald database is marked as
suspicious. I mean, SQL marked this database with that flag and now I =
not get the old data.

Could you help me? is kind of urgent


Rafael Gomez
Cel: 58 14 337.11.22
Charter Communications International Venezuela

Tel: 58-2-576.60.80
Fax: 58-2-572.43.43

For more information about this list (including removal) go to:

For more information about this list (including removal) go to: