Dev (12/30/2011)

---

Brandie Tarvin (12/29/2011)

---

That's...

Thank you both. It never occurred to me that SQL would treat DISTINCT the same way it treats aggregate functions (via error code), even though I know the basics of...

Would the DAC account help in a scenario like this? Or am I barking up the wrong tree?

I've never had to, so I can't tell you the consequences of doing so. But a few years back, I know of one SSC poster who swore by a specific...

That's a good point. I'll check...

GSquared (12/29/2011)

---

Brandie Tarvin (12/29/2011)

---

Question for those of you commenting on external drives. The few times I have tried it (both on a local db on my laptop and from a...

Forget about creating a new .LDF file. You can't do anything right now anyway except follow the steps as they were given you.

Vertigo44 (12/29/2011)

---

This was a server that one of our customers purchased and never told us about until a week ago. It was not even located in our datacenter. They are...

Question for those of you commenting on external drives. The few times I have tried it (both on a local db on my laptop and from a server remotely), I...

Stefan Krzywicki (12/29/2011)

---

GSquared (12/29/2011)

---

Dev (12/29/2011)

---

I thought some "Magic" (recovery trick) will happen & that DB will be saved. It’s a nice learning opportunity that I missed. However the...

GilaMonster (12/29/2011)

---

Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts, presentations, webcasts and screaming lightning talks, I...

Just to append for future readers:

A backup of a drive where the .ldf, .mdf, or .ndf files live is not a SQL Server backup. From my experience, if the backup...

Randy Doub (12/29/2011)

---

Nice. I think I'll do the same!

I looked there in the begining. But not knowing anything about...

Tape

HA! Figured it out. Rather than use the ActiveX Task, which is deprecated and may be removed from SSIS without further notice in the future, I've adapted your code into...