Re: Backing up transaction logs
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/30/04
- Next message: Sue Hoegemeier: "Re: Blocking UDP Port 1434"
- Previous message: Jack Wachtler: "Beginner security questions"
- In reply to: Travis: "Re: Backing up transaction logs"
- Next in thread: Travis: "Re: Backing up transaction logs"
- Reply: Travis: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 30 Mar 2004 14:13:49 -0700
You'll need to get the details of the failure to resolve
the issue.
o find the details of the failures with maintenance plans,
you need to go to the maintenance plans, right click on the
plan that is failing and select Database Maintenance Plan
History.
-Sue
On Tue, 30 Mar 2004 12:41:21 -0800, "Travis"
<anonymous@discussions.microsoft.com> wrote:
>Thanks for your reply. I set the job owner to sa like
>you suggested. However, now I am getting this error in
>my event viewer. I think it says it was invoked by
>administrator because I went to jobs and right clicked
>and selected run? Any other ideas? Thanks
>
>SQL Server Scheduled Job 'Transaction Log Backup Job for
>DB Maintenance Plan 'DB Maintenance Plan1''
>(0xD35D479ECC6E8840A93C091C8876BF07) - Status: Failed -
>Invoked on: 2004-03-30 15:29:31 - Message: The job
>failed. The Job was invoked by User
>xxxdomainxxx\Administrator. The last step to run was
>step 1 (Step 1).
>
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>
>
>>-----Original Message-----
>>Have a look at these. I tend to set job owner to sa to
>avoid this
>>
>>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;241643&Product=sql2k
>>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;834124&Product=sql2k
>>
>>--
>>HTH
>>
>>Jasper Smith (SQL Server MVP)
>>
>>I support PASS - the definitive, global
>>community for SQL Server professionals -
>>http://www.sqlpass.org
>>
>>
>>"Travis" <anonymous@discussions.microsoft.com> wrote in
>message
>>news:15b4301c41684$27b8e7a0$a301280a@phx.gbl...
>>> Hi,
>>>
>>> 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)).
>>
>>
>>.
>>
- Next message: Sue Hoegemeier: "Re: Blocking UDP Port 1434"
- Previous message: Jack Wachtler: "Beginner security questions"
- In reply to: Travis: "Re: Backing up transaction logs"
- Next in thread: Travis: "Re: Backing up transaction logs"
- Reply: Travis: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
