Viewing 15 posts - 166 through 180 (of 225 total)
Hi DP,
You should be able to right-click on the maintenance plans and choose 'Modify' to edit them but as you can't see them you can't do that. What happens...
July 25, 2008 at 8:11 am
Hi,
Are we talking about Maintenance Plans or SQL Server Agent Jobs? You can create new plans by simply right-clicking 'Maintenance Plans' and choosing 'New Maintenance Plan' or 'Maintenance Plan...
July 24, 2008 at 9:41 am
Neteng,
Take a look at this msdn article although the script can be used it might be easier for you this way.
As always make sure you have a recent backup.
Regards,
Mark
P.S...
July 22, 2008 at 2:14 am
I would be inclined to leave well alone unless as previous posters have said the update/service pack resolves specific problems that affect your server.
July 16, 2008 at 10:18 am
I agreed with Gila's previous posts, it's very straightforward to rename the sa account and just as easy to assign a strong sa password. Even better to disable the...
July 11, 2008 at 1:13 am
Michael.varriale (6/25/2008)
Hey Mark, Any update on your script to install 8 instances of SQL 2005 and sp2? What about the maintenance plans?Vince great scripts
Hi Michael,
Well we have now...
July 2, 2008 at 6:43 am
Steve,
Perhaps I should have mentioned this but be aware of some of the problems you could face as mentioned by Steve and more recently George in earlier posts.
Although i've used...
January 24, 2008 at 6:44 am
Hi Steve,
From within SSMS connect to Integration Services and login. Once you've logged in you should see 'Stored Packages' under Object Explorer which you can then expand and then...
January 24, 2008 at 5:59 am
Steve,
If your working with named instances then this article will also be useful
http://msdn2.microsoft.com/en-us/library/ms137789.aspx
Regards,
Mark
January 23, 2008 at 4:38 am
Steve,
Ok, if I connect to integration services on my specified sql server where my maintenance plans reside and then expand 'Stored Packages', 'MSDB' & 'Maintenance Plans' I can see a...
January 23, 2008 at 4:30 am
Hi Steve,
If you are referring to SQL 2005 then try using SSIS to move plans between servers & instances. There are a few doc's on the web that will...
January 22, 2008 at 1:51 pm
Steve Jones - Editor (10/5/2007)
Yeah, my formatting doesn't work well.I'll try to edit this down. Waiting on a new built to get me motivated 🙂
Thanks Steve
October 5, 2007 at 9:35 am
I agree with Vince, when I first attempted to split the mssqlsystemresource.ldf to a different drive I experienced all sorts of problems (including problems applying hotfix KB934458). Save yourself...
October 3, 2007 at 2:32 am
Sorry Rocky but I have not had a chance to test this... unexpected work load etc, perhaps someone else here has some knowledge of this?
I would be interested to know...
September 6, 2007 at 5:56 am
Viewing 15 posts - 166 through 180 (of 225 total)