I'm imagining about 60,000,000,000,000 😉

CirquedeSQLeil (10/4/2010)

---

WayneS (10/4/2010)

---

Lynn Pettis (10/4/2010)

---

As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way...

Your point is well taken Craig.

Everyone wants the same thing here - i.e. a sensible and reliable backup/recovery plan.

Oh, I know you have... I've read lots of your other posts. (Note to self: is that a light-saber...

See my 'RAID is not a backup' comments. In that case, your recovery plan is not worth the virtual paper it is printed on. If the log fails (corrupted) (and...

Hi Gail;

Yes, the logs are mirrored with RAID 1.

The "deleting" is done through your favourite tool, DPM.

Our sysadmin just told me that DPM does the full backup then deletes the...

Thanks Gail, Craig;

I have followed up with our CIO who has tasked one our managers with getting our act together on this. I'll be involved and will keep you posted.

Once...

Update:

I'm told that what's happening here is that we do full backups each night. The following morning, the log files are 'deleted' and allowed to fill through the day until...

hallhome (9/17/2010)

---

Update: I took Gail's advice and moved tempdb to another drive and recycled SQL Server. The database in question was able to recover and I was able...

Thanks to the input that was provided here, our CIO has initiated a full review of our backup policies and the SLA's we have with our clients.

I owe you all...

GilaMonster (9/14/2010)

---

No, not at all.

All that you need is for the...

GilaMonster (9/14/2010)

---

p.s. Thank you.

I thought you were talking about me in the main...

Thanks Gail,

You're one of the people I was thinking of in the postscript to my original post.

So yes, barring a meteor impact or extraordinary chain of events, we can recover...

GilaMonster (9/9/2010)

---

Nope, the opposite.

For 61 databases, the space in the...

Gail,

I ran this on a dev server:

select log_reuse_wait_desc,count(log_reuse_wait_desc)

from sys.databases

where recovery_model_desc = 'FULL'

group by log_reuse_wait_desc

and got this:

LOG_BACKUP61

NOTHING 7

I'm...