Backup issues

Hi there
My SQL server backups are running as nicely as they used to. Recently I
got the following error:
Message: The job failed. The owner () of job DB Backup Job for DB
Maintenance Plan 'Daily Backup1' does not have server access.
I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
deleted the existing maintenance plans and created identical new ones
which worked fine for a couple of weeks. Now this error is back. What
exactly is causing this? Is there another way to fix it without deleting
and recreating these backup jobs?
Thanks
HamishTry setting the owner of the job to "sa", you can do that for the jobs that
Maint Plan creates.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%237GPzUzuGHA.4460@.TK2MSFTNGP04.phx.gbl...
> Hi there
> My SQL server backups are running as nicely as they used to. Recently I
> got the following error:
> Message: The job failed. The owner () of job DB Backup Job for DB
> Maintenance Plan 'Daily Backup1' does not have server access.
> I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
> deleted the existing maintenance plans and created identical new ones
> which worked fine for a couple of weeks. Now this error is back. What
> exactly is causing this? Is there another way to fix it without deleting
> and recreating these backup jobs?
> Thanks
> Hamish|||Tibor Karaszi wrote:
> Try setting the owner of the job to "sa", you can do that for the jobs
> that Maint Plan creates.
>
Really dumb question then, how do I do that?|||Edit the job. You find the jobs folder under SQL Server Agent.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%234cem93uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Tibor Karaszi wrote:
> Really dumb question then, how do I do that?