Sunday, February 26, 2012

Error in Event Viewer

I am having trouble backing up my SQL DBs using Retrospect software to a NAS
box. I am thinking this error might have something to do with it. What does
it mean? Thanks for any help!
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status: Failed -
Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not
obtain information about Windows NT group/user 'PULIZ04\Administrator'.
[SQLSTATE 42000] (Error 8198)).
The maintenance plan has been made with a user who probably doesn't exist
anymore.
You might try to edit the maintenance plan and use a user name and password
with full admin rights at
the database. Simply right click the maintenance plan and choose edit
properties. Within the properties it's possible to edit the user.
Regards,
Johan
"scottdog129" <scottdog129@.discussions.microsoft.com> schreef in bericht
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).
|||Yes, that is the resason for your backup failure. That happens now and then
and there are different causes and fixes. The best way is to avoid such a
problem by changing your job owner to a SQL login such as sa.
Gary
"scottdog129" <scottdog129@.discussions.microsoft.com> wrote in message
news:6E7E1780-9C65-49F6-AFE1-088266C1920C@.microsoft.com...
> I am having trouble backing up my SQL DBs using Retrospect software to a
NAS
> box. I am thinking this error might have something to do with it. What
does
> it mean? Thanks for any help!
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0xAE93FC57F4BBB24EAC6F90AD165B993F) - Status:
Failed -
> Invoked on: 2004-11-19 02:00:01 - Message: The job failed. Unable to
> determine if the owner (PULIZ04\Administrator) of job DB Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could
not
> obtain information about Windows NT group/user 'PULIZ04\Administrator'.
> [SQLSTATE 42000] (Error 8198)).

No comments:

Post a Comment