I'm going to have to do more research. I'm now being told this happens when disabling jobs through the GUI, not just the code.

We've apparently had the same problem. In disabling jobs (jobs that restore backups down to our Dev server) during month end, the job gets disabled but then still runs as...

You never did answer Gail's question.

Is...

It sounds like this latest question is something different from your original post. If that is indeed the case, please remember that new & unrelated questions should have their own...

chrisph (3/31/2010)

---

Is it possible the server team could go back and restore the .mdf from their backup procedures?

I would check/ask if they have "volume shadow copy" enabled on the server....

But disabling them first will guarantee you'll be able to delete them afterwards.

Can't logon to the system...

Glad we could help. BTW, setting up a restore as an auto-job is probably going to be the hardest part. Once you have it set up, you can pretty much...

If the software was already staged, chances are that's why it's skipping the software check. It's probably been short-cutted to do so.

Basically, you'll have to manually do the checks to...

John Rowan (3/29/2010)

---

I grew up in South Omaha until middle-school age and I've been out in West Omaha ever since. We live out by Boys Town now. So...

Actually, I just figured out what's going on in terms that I can understand.

My explanation to myself is:

It's not that you have a blocked index, because honestly, an Index...

Ah. We posted at the same time. I see your explanation now.

Do you have the text of the Blocked Index errors you were getting?

Ditto to what Jason said. I'm just confused because I don't know what a blocked index is and what allowing page locks has to do with it.

If you could clarify...

Waseem Jaleel (3/29/2010)

---

since he knows the max size the log can reach, is it not ok to keep the initial size and max size the same with auto shrink disabled?...

Do not mistake "want" for "need". There is no need. Technically, you could run a 1 TB size database on one file and one filegroup.

The idea of splitting your database...

The one thing to note about killing connections this way is that it does NOT prevent those connections from reconnecting after they've been disconnected. The best way to do that...