Sachin Nandanwar (3/22/2011)

---

So when a checkpoint...

Hence the reason, Sachin, why I...

Jason, you need to change that out for the image of Boo in her monster costume. @=)

Oh, hey, completely non-SQL related link:

If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).

http://www.youtube.com/watch?v=XiZuvJ48MZ0

GilaMonster (3/22/2011)

---

Brandie Tarvin (3/22/2011)

---

This particular piece of advice, which doesn't have a whole lot to do with the OPs problem (other than the bit about shrinking the files after doing...

Sachin Nandanwar (3/22/2011)

---

mail.pnreddy (3/21/2011)

---

I was able to shrink successfully.

Here are the steps i followed.

Change the DB back to Simple If it is in Full mode.

Change it back to Full mode.

Use...

GSquared (3/22/2011)

---

Brandie Tarvin (3/22/2011)

---

<groan> Why oh why do the same "bad" solutions keep popping up when there are tons and tons and tons of articles telling people why it's a...

<groan> Why oh why do the same "bad" solutions keep popping up when there are tons and tons and tons of articles telling people why it's a bad idea to...

Do you have another disk drive handy?

Have...

Glad we could help. Mind posting your solution in case anyone has a similar issue?

Wow. I am seriously brain-dead today that I didn't see that solution.

Thanks, Lutz. Sometimes it just takes a second set of eyes. I've been looking at this code for too...

Ah, yes. Ye good ol' bulk insert or BCP.

Transactions while DB is in SIMPLE recovery mode.

Try searching without the @ on his handle.

Glad we could help.