Stefan Krzywicki (10/20/2011)

---

If you backup the transaction log and change the Recovery Mode to Simple you should be able to delete the second file. Then you can change it back...

So I tried the "hack" in the MS Connect item (see my earlier post for the link) and it doesn't work for me. As soon as I try to add...

Roy Ernest (10/20/2011)

---

Brandie, I think there is another one cause I remember distinctly that you have to do a EMPTYFILE before you try to delete the secondary file once again...

ONLINE

george sibbald (10/20/2011)

---

If you have a full backup I would be interested to see which files are returned...

Just finished running it, MOF. It didn't find any problems with the database. Also ran it against MASTER (because...

I don't want to recreate the file, actually. I just want to remove it.

Changing my T-SQL statement to REMOVE FILE I get:

Msg 5009, Level 16, State 9, Line 2

One...

Grrrr. Me be troll. "PANTS! PANTSPANTSPANTS! I dare you! GRRRRRR".

And on a more serious note, I need help badly, please. This one has me totally confused and I can't seem...

OMG! It's back! It's really really back!

http://www.commodoreusa.net/CUSA_Vision.aspx

I have such fond memories of my state-of-the-art Commodore 64. Now I can get a new one! @=)

Soon as I can scrape up some...

Harold and Kumar get pantsed.

Lyrica

Am I pants? Do I even look like pants? Trust me. I'm a doctor.

EDIT:

Amy Pond, there's something you better understand about me 'cause it's important. And one day your life...

Of course, you realize, this means pants!

Where there's a will, there's pants.

Ninja's_RGR'us (10/18/2011)

---

Brandie Tarvin (10/18/2011)

---

Ninja's_RGR'us (10/18/2011)

---

pre-edit bad...

Ninja's_RGR'us (10/18/2011)

---

pre-edit bad pun that might...