May 31, 2012
tom

Automate SQL Server 2008 backup script failing to run

Question

I have created a maintenance plan but when I try to execute I get the error:

Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'XX\Administrator', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

I have given administrator db owner access but still get the error, what am I doing wrong?

Asked by Techboy

Answer

Usually when this happens you just need to edit the job and save it again. This will “usually” fix the problem.

Failing that try changing it to run under a SQL Account such as the sa account so that it doesn’t need to check for domain credentials before running the job.

Answered by mrdenny

Related posts:

  1. how to Automate the SQL Server 2008 Database and OLAP backup?
  2. SQL Server backup jobs run twice, but appears to be scheduled once
  3. Run a SQL Server 2005 Job as Administrator on Windows Server 2008
  4. SQL 2005 Diff backups failing – no full backup exists?
  5. RSync shell script failing to run as CRON, runs fine manually

Leave a comment