Thank you, Steve, for the feedback. I'll be installing CU1 on a test server this week.

Shawn Melton (12/12/2010)

---

bethrich (11/18/2010)

---

In SQL 2008 SP1 (not R2), running in VM with a NAS, I have intermittent failures in the reporting step of the MPs. The job fails, though...

Revisiting the intermittent failure of maintenance plans and trust or no trust: I still vote no confidence.

A few days ago the AV guy forced updates on all the DMZ servers...

Jeffrey,

Good point. This is in the MP history:

The requested operation cannot be performed on a file with a user-mapped section open.

I knew that in my past research, file contention had...

Jeffrey,

It's frequently the transaction log backups that fail, but of course that's because they are run far more often than other tasks. We've tried excluding the reports from virus scan...

I'm pretty much stuck with maintenance plans since I'm the only DBA in the shop and backed up by non-DBAs. In SQL 2008 SP1 (not R2), running in VM with...

Did you ever get a resolution? I have the same situation with intermittent failures on two servers. We just built two additional servers and I'm sure this problem will multiply....

Eddy, I'm not sure where I got this reorganization code. This one doesn't cap pages, but works for SQL 2000. I think it came from the SAP world. The actual...

Eddy, it's well worth a little time to set up selective reorganization for indexes. I use that for several large SAP databases. To address the issue of a too-large run,...

SQL Saturday 33 was absolutely wonderful for those of us who don't have many training opportunities. I work for a government agency that has had no choice but to cut...

Here's some code I did for a data-driven conversion in SQL 2005. It should work for SQL 2000, but you won't need the section for the varchar(max).

First the stored proc:

create...

It is indeed related to Backup Exec. I have seen these on some of our older servers where Backup Exec has been removed.

Here is the script as generated from the server. Please set the proper login if you use this, as well as the path to your job log files.

USE [msdb]

GO

/****** Object:...

Kris, This is covered somewhere else, but I'll post it here because I don't have a link. Credit goes to someone else.

Set up a job using an ActiveXScript. Change...