SQL Server Performance Forum – Threads Archive
backup woesHi,<br /><br />I am running two sql servers on an active/active cluster. They run sql server 2000 enterprise. I have had no trouble in the past with the backup jobs, but recently they have been failing with the following error.<br /><br />The job failed. Unable to determine if the owner (domaindomainuser) 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 ‘domaindomainuser’. [SQLSTATE 42000] (Error 819<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />).<br /><br />The domain user is the same user that the sqlserveragent service runs under. This account has full access to the network directory where the backups are written.<br /><br />It doesn’t fail everytime, just sometimes??? Nothing has changed on this cluster or the network since it was installed. Any ideas?
I’ve moved to this place.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Ensure SQL Server is on latest service pack, refer this KBAhttp://support.microsoft.com/?id=821334 for information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
This can happen if your SQL Agent account does not have enough rights to query the AD for information about the login that is set as the job owner. If possible set the job owner as ‘sa’. As long as the SQL Server agent account have rights to the network directory the job will work. PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User
Just check, if the job fails, when the server1 resources are on server2 ? Thanks N’ Regards