June 1, 2008 at 11:26 pm
Hi All,
In my development server i found this below job, I would like to know what this job do. Its working correctly on this server but when exectuted online its giving error.
Please help.............
EXECUTE master.dbo.xp_sqlmaint N '-PlanID B922C47C-52D2-4A3D-B1C9-540141917AE7 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB -UseDefDir -BkExt "BAK" '
Thanks in Advance,
Syed Sanaullah Khadri
DBA
June 2, 2008 at 12:34 am
This looks like a SQL 2000 Maintenance Plan script - the new 2005 Maintenance Plans make use of packages and usually look like the folowing:
/SQL "Maintenance Plans\UserDBs" /SERVER SQLSERVER /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false /REPORTING E
The job script you mentioned looks like a Backup Maintenance Plan
Thanks
Kevin
June 2, 2008 at 12:46 am
Hi Kevin,
Yes its SQL SERVER 2000 maintanence plan querry, but i have connected that server usin sql server 2005.
EXECUTE master.dbo.xp_sqlmaint N after setting this as maintenance plan i am executin this and i am getting this error
Message
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). NOTE: The step was retried the requested number of times (1) without succeeding. The step failed.
I dont know what to do i am still a learner...............
June 2, 2008 at 1:03 am
Have a look at the security between these servers, the service account that starts up the SQL Agent Service in particular.
let us know what details you have around this
Thanks
Kevin
June 2, 2008 at 1:35 am
Hi
Got the desired result, ih have visited this link and got the explanation
http://www.mssqltips.com/tip.asp?tip=1016
Very useful
Thanks,
Syed Sanaullah Khadri
DBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply