Backing up transaction logs
From: Travis (anonymous_at_discussions.microsoft.com)
Date: Tue, 30 Mar 2004 10:23:53 -0800
I have a single Windows Server 2003 and SQL Server 2000.
I have created a maintanance plan to back up my SQL data
base as well as the transaction log. I am getting this
error in my event viewer and haven't been able to figure
out why. I have recreated the job, making sure I was
signed in as administrator and it didn't change
anything. I have also gone into Logins under enterprise
manager and the user xxxdomainxxx\administrator does not
exist and I an not able to add it (it says it can't find
it). Any help is appreciated. Thanks
SQL Server Scheduled Job 'Transaction Log Backup Job for
DB Maintenance Plan 'DB Maintenance Plan2''
(0xB829073EE903F94A8783BC84D54506C6) - Status: Failed -
Invoked on: 2004-03-30 13:00:00 - Message: The job
failed. Unable to determine if the owner
(xxxdomainxxx\Administrator) of job Transaction Log
Backup Job for DB Maintenance Plan 'DB Maintenance Plan2'
has server access (reason: Could not obtain information
about Windows NT group/user 'xxxdomainxxx\Administrator'.
[SQLSTATE 42000] (Error 8198)).