Too wishy-washy. A lot of conflicting advice in this editorial. Either take a stand one way or the other or don't even bother writing an editorial like this in the...

Lynn Pettis (8/7/2009)

---

Hate to tell you, but discussion threads here...

Old Hand,

I was expressing my PERSONAL opinion that I DO consider that elementary type of db ignorance of DBA team members so common as frightening. Particularly, on production databases holding...

Disagreeing with someone is much different than personally attacking them. Show me anywhere I have attacked anyone personally?

Ol'SureHand (8/7/2009)

---

Michael Oberhardt (7/14/2008)

---

I've had a few issues with rogue transaction logs as well (on MSDE at any rate). Even on autoshrink I've had them grow to over 10GB, and...

Uh oh! thread hijack...GSquared, stay on point dude. We are talking about corporate production databases, not automobiles... apples and oranges....

I'll take your word for it Gail, but I must say with billions of dollars of corporations revenue on SQL Server databases nowadays this is truly a scary thing to...

Whooaaa! really? Well maybe it is just me but if I had someone on my DBA maintenance team/rotation that did not know what the different db recovery models were then...

Ok, if that was your only point then I guess I'm not understanding the point of bringing simple mode up on a dev server in a thread where the t-log...

Because if that 100gb physical space is not reclaimed another t-log on that server may not be able to expand if that 100gb is the last 100gb available on the...

WRONG! A db in Simple recovery mode does NOT guarantee that the transaction log will

shrink in size or not grow and thus cure an out of disk space problem....

This is a perfect example of non dba technical staff having a little knowledge just enough to be very DANGEROUS! Let alone them having sysadmin access to that production box...

Yep, and this will work just as well..in SQL 2000,2005, & 2008

SELECT count(*) FROM sysobjects

WHERE type = 'U' AND name NOT LIKE 'dt%'

GO

However, I must say that this is a...

No it isn't... I mentioned it back on the first page of this thread. No data was lost..I am not sure where you are getting that from. the files were...

Yep, now that we have the list, getting the last modifed date of the detached files is a piece of cake. Going forward, all detached database files will be moved...