If it never recovers... not sure how long to define never, as I had one take
about 6 hours on a old server... but anyway, if it doesn't recover then you
can do some command-line magic, expand the tempdb and whatever else needs
done then it should finally recover.. Sorry, I don't remember the
"command-line magic" but if no one else provides it I will dig through my
wall of books and find it.
> -----Original Message-----
> From: firstname.lastname@example.org
> [mailto:email@example.com]On Behalf Of Bob's Lists
> Sent: Saturday, September 23, 2000 2:40 PM
> To: firstname.lastname@example.org
> Subject: RE: [Emerald] Clearing out history - pointers?
> Importance: High
> > > > I would recommend calling our support group. They can help you
> > > > expand your database size.
> Dale we expanded the database, then ran the manual maintenance to
> trim it -
> but disaster has struck. The thing ran for an hour or two, then
> popped up a
> message that it had run out of space on the device. Since then we
> have been
> SQL Enterprise Manager says Emerald is 'recovering' whatever the hell that
> means (I mean I think I know what it means but how long is it supposed to
> take we waited hours!)
> We've been trying to call you for hours, keep getting an answering machine
> but once, we got a receptionist who says 'everyone is out'.
> Can you please give me a support number I can call!
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: