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 =
first
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. =
This
procedure ist covered in the SQL Books online, in addition search the =
MSKB
for 'suspect recover'. Article Q180500 describes a very common =
situation
where a database is marked as suspect, but it depends on your =
situation.
If the described procedure (sp_resetstatus) does not help - you do have =
a
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 * http://sang.net * mailto:pesa@sang.net
* Microsoft Solution Provider - Internet/Intranet Specialist *=20

-----Urspr=FCngliche Nachricht-----
Von: Rafael Gomez [mailto:rgomez@c-com.net.ve]
Gesendet: Donnerstag, 13. Juli 2000 00:02
An: Emerald
Betreff: [Emerald] Corrupt Emerald?

Hi
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 =
can
not get the old data.

Could you help me? is kind of urgent

Thanks

Rafael Gomez
rgomez@c-com.net.ve
Cel: 58 14 337.11.22
Pager: 9106973@skytel.com.ve
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:
http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart