update statistics could make a difference as well. I would look and making sure you hard set the memory allocation to make sure SQL Server doesn't try to hog all...

your optimization job includes reindexing or indexdefrags those are logged opperations and will cause the log to grow like it is.

Wes

you can use activex to enable or disable steps causing DTS to loop or support better branch decision trees.

It requires you set global variables then evaluate them to turn...

I try to sleep alot the week before PASS for the same reason and always try to take the following monday off to recoupe

RAID 5 should be fine if you are not doing any writes to the 5 databases in question. I would put TempDB on RAID 0+1 due to all temp objects...

I don't think there is any uninstall of the MDAC. I'm not sure installing an older version would fix that ether. SQL 2000 installs on windows 2003 and that has...

If you have need for compresses backups I would look at SQL LiteSpeed or Idera's SQL Safe both do real time compression of the backup file and reduce the amount...

MOM is NetIQ underneath. We use MOM here. I've use OpenView from HP alot in the past as well. Both do a good job monitoring and allowing you to run...

These tools gather data and rap it up in a nice neat package for PSS to look at. if you look at what SQLDIAG does it pulls all the logs...

That means you were trying to backup the log on databases that were set to simple recovery. I would rework your job and not tamper with system databases that are...

DumpEL is available from the Windows Resource kit, I use it to dump the log then load it into a table parse it any way you like.

Wes

Just remember if you to a backup TRUNCATE ONLY and you are currently backing up the tlogs you will screw up your restore options. Very rarely do I EVER recommend...

Using profiler to do anything but spot check problems isn't recommended. Setup a server side trace if it is something you want to track over time. Profiler can consume as...

If you try to make a change to the job itsself it won't let you because the job is running. If you modify say a stored procedure that the job...

Unless you restrict them from tembdb yes?

Wes