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

I agree with Grant. If you can do it, go for it. I don't see any Cons to the situation and only Pros.

Just don't make the mistake of setting Max...

What exactly is your definition of a "Blocked Index"?

I've never heard that term before and I find myself wondering what it has to do with allow_page_locks being on or...

Not sure what MOSS is, but here goes.

Open up Books Online and lookup ALTER DATABASE...

river1 (3/29/2010)

---

I'm receiving this error when executed the stored procedure that i posted:

Msg 217, Level 16, State 1, Procedure RemoveLigacoes, Line 48

Maximum stored procedure, function, trigger, or view nesting level...

Full backup is not the same thing as Full Recovery Mode.

Right click the database, go to Properties. Check the Options page in the popup window. Does the second line (Recovery...

You have to assign that right through the Active Directory GPO. If the the...