Viewing 9 posts - 1 through 10 (of 10 total)
Still errors using sql agent job. The maintenance plan works fine using DTEXEC from the command line in a batch file. Please, anybody with any other ideas?
March 10, 2011 at 7:48 am
I'm running a 32 bit processor so i don't think that's relevant. From what i've read it seems maybe a dll needs to be re-registered but i don't know...
March 3, 2011 at 7:23 am
OK, here's an update. I ran the plan from the command prompt suggested by magasvs using:
DTEXEC /SQL "Maintenance Plans\MaintenancePlan" /SERVER "T2SERVER\MSSQLSERVER2K8" /USER sa /PASSWORD /X86 /CHECKPOINTING OFF...
February 18, 2011 at 9:03 am
If I try to just execute the maintenance plan it tells me there's an error, check job history for details. I changed to owner sa, uncategorized and still get...
February 18, 2011 at 8:52 am
Still not working. I've created a new USER on the system and applied all the SQL groups that were created when I installed SQL Server 2008. I've set...
February 18, 2011 at 8:05 am
I haven't tried. I'm not sure how as I'm still pretty new at this. I'll give it a go and report back.
February 17, 2011 at 7:04 am
Thanks for the reply... I'm using the SQL Server Management studio on the server. The history log for the maintenance plan has nothing in it. It seems the...
February 17, 2011 at 6:06 am
10.0.4000.0 SP2 Enterprise is the version that's running, i think it's the most up to date. I had this problem before upgrading to SP2 and it remains so i...
February 16, 2011 at 7:15 am
Viewing 9 posts - 1 through 10 (of 10 total)