Ian Scarlett (10/30/2009)

---

Then it could be the transaction log (or another file in the database) that is taking up all the space.

Run sp_helpdb [dbname] ...that should tell you which file...

I have tried it, but I did it again just to make sure.

dbcc shrinkfile (jeff_data, 5000)[\code]

DbIdFileIdCurrentSizeMinimumSizeUsedPagesEstimatedPages

2415008720128101184101184

peterhe (10/30/2009)

---

What service pack are you running? I remember SQL Server 2k5 had a bug. If you have SP1 or earlier and use blob data type (e.g. text), the database...

Thanks for the link. The perfmon counter showed that I am not actually processing the messages. So now I need to know why this one queue isn't processing...

Actually, I would love nothing more than to shut off the parallelism in the system (heck in all of our systems). However, convincing my manager of that is a...

Sorry Gila, I mistyped. Obviously, the CXPacket will decrease if I change the setting and turn it off. However, then it will go else where. So I...

Any thoughts on how to go about figuring out what is causing those? Pretty sure that turning off the parallelism option isn't going to solve anything, even though I...

The ol' magic 8 ball.

Really? So I all have to do is to increase the file size and it will automatically do it?

Wow, if that is the case, that was significantly easier than...

Jeffrey,

Thanks for the suggestion. That is exactly what I did.

Fraggle

Eddie,

Great write up. That gave me a lot of information that I had been looking for.

By chance is this documented somewhere so I can read more on it, or...

So we go live with the client, yesterday 10/1. After all of the issues were resolved at 3:30 a.m. on 10/2, I was poking around the system to make...

Michael Valentine Jones (9/30/2009)

---

Fraggle-805517 (9/30/2009)

---

Mark Marinovic (9/30/2009)

---

Fraggle-805517 (9/30/2009)[hr

Ok, but why do you still do SQL Backups is my question. What is the reason for them vs doing the SAN...

Mark Marinovic (9/30/2009)

---

For me...

Michael Valentine Jones (9/30/2009)

---

Fraggle-805517 (9/30/2009)

---

Ask the vendor to write up in detail exactly how they would do a database recovery to a specific point in time to a new database...