I created a maintenance plan to back up a database as a file to another server. Full backup was specified. The job has been running for about 3 months, then quit last night (after the server was rebooted). Error is:
Message
Executed as user: xxxxx\Administrator. The command line parameters are invalid. The step failed.
not sure what to do to fix this - -
Do a profiler trace to see if it's a TSQL issue somewhere, maybe the plan was accidentally changed somehow.|||I turned on Profiler to trace database backups - now all the backups are running fine -|||This is typically caused by the account changing the password. If you change the password of the account you used to run the job, you won't see any problems until you reboot your server/restart SQL Server service as this is the only time that the new security credentials will take effect.|||the jobs were created by and are run under the domain master system administrator account|||
Please go the SQL server jobs and change user domain\Administrator to sa (SQL Administrators).
it should be resolve......
No comments:
Post a Comment