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...

It's a good suggestion, but how do I get the dynamic file name (which has a date appended to it) and path (which changes depending on the environment I'm running...

Well, you were right. There was no other way. We had to do the service restart over the holiday weekend, but it did work. In this case, it didn't prevent...

There's not a whole lot to...

Since it's doubtful I'll be around for the next four days...

Happy Holidays to anyone who celebrates. And happy long weekend to those who don't celebrate but take advantage of the...

I know you meant the service. It's just that we've become a not-quite-24 x 7 shop with over 20 databases that multiple applications depend on, so finding a time in...

Gail,

I think I just found something. Read Jag's post here: http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/71d3cd0b-ce4d-4202-8e3b-38b38da90a5b. It sort of makes sense to me, but I'm wondering what else could be affected if I take this...

Any chance I can get some help here: http://www.sqlservercentral.com/Forums/Topic1225123-1550-1.aspx?Update=1

I'm having an issue with two RESTORE DATABASE jobs not killing completely.