GilaMonster (9/17/2010)

---

Brandie Tarvin (9/17/2010)

---

You can't shrink other databases while the disk is full. SQL Server requires space in which to do the shrinking, in which to add markers or throw...

hallhome (9/16/2010)

---

Here is what was in the errorlog

08/31/2010 09:02:13,spid52,Unknown,The transaction log for database 'E_Y' is full. To find out why space in the log cannot be reused see the log_reuse_wait_desc...

hallhome (9/16/2010)

---

Here is what was in the errorlog

08/31/2010 09:02:13,spid52,Unknown,The transaction log for database 'E_Y' is full. To find out why space in the log cannot be reused see the log_reuse_wait_desc...

GilaMonster (9/16/2010)

---

Don't...

LutzM (9/16/2010)

---

Maybe a stupid question:

Would it help to detach the other DB's (assuming that option is available) and move the related mdf and ldf files to a different drive/server to...

WayneS (9/16/2010)

---

If I had any database problem, I'd be following every single word that Gail says concerning it to the "T".

@hallhome...

Well here's another good question. Of that ±3 hours workload, what steps absolutely cannot be performed online assuming SQL Enterprise?

I'm pretty sure the list is not so long that...

hallhome (9/16/2010)

---

I think the cause is known - the database is using FULL recovery model

and the transaction logs have never been backed up. Only full database backups have been...

If for some weird reason the error leading to the pending state is erased from the log, then restarting the servger might get it logged this time (not sure, but...

It does... it's called get more than 1 server and upgrade one at a time.

Not a fancy name but it does get the job done.

BTW, our advice will only cost you 1% of the total value of the contract when you get it :w00t:.

No you're pretty much on the nose. No downtime really means no "user aware" downtime.

Assuming you are spreading the load accross servers, start the maintenance on the slowest time...

Ok guys, don't make me call your mother on this!

How will restarting the server help if the recovery fail because of missing space??

Wow, 1.3 M readers @ 1$/week, I like that :w00t:.

Seriously, it's another good option.

The only option I reject is you stopping this series. Everything else is doable....