Viewing 14 posts - 1 through 14 (of 14 total)
Thank you, Steve, for the feedback. I'll be installing CU1 on a test server this week.
January 26, 2011 at 10:54 am
Shawn Melton (12/12/2010)
bethrich (11/18/2010)
December 13, 2010 at 11:36 am
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...
December 2, 2010 at 12:16 pm
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...
November 19, 2010 at 2:04 pm
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...
November 19, 2010 at 11:06 am
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...
November 18, 2010 at 11:31 am
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....
August 27, 2010 at 8:30 am
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...
May 6, 2010 at 10:58 am
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,...
May 5, 2010 at 11:09 am
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...
March 19, 2010 at 1:56 pm
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...
July 31, 2009 at 10:56 am
It is indeed related to Backup Exec. I have seen these on some of our older servers where Backup Exec has been removed.
July 29, 2009 at 10:53 am
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:...
February 9, 2009 at 11:40 am
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...
February 6, 2009 at 11:40 am
Viewing 14 posts - 1 through 14 (of 14 total)