Re: Backing up transaction logs

From: Travis (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 13:31:24 -0800

Thanks for your reply!

I did what you said and it looks like it is backing up
the "master" and "msdb" databases and it shouldn't be.
So should I recreate the mantenance plan and not include
these in the backup, or will I need them?

Thanks!

>-----Original Message-----
> 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)).
>>>
>>>
>>>.
>>>
>
>.
>

Relevant Pages

  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... In the "Maintenance Plan" node of the log viewer: ... Every entry has a red X next to it. ...
    (microsoft.public.sqlserver.tools)
  • Re: Run job from DTS package
    ... DTS package then you can have the Account under which it runs have perms to ... How do you propose to know that the backup job you have selected comes from ... Which maint plan? ... You may have one for logs and one for some databases, ...
    (microsoft.public.sqlserver.dts)
  • Re: sqlmaint.exe hangs
    ... We have multiple maintenance plans. ... One such plan for database txn log backup, takes txn log backup on each ... When i check the sysdbmaintplan_history tables it shows all databases txn ...
    (microsoft.public.sqlserver.tools)
  • Re: backup error - single user mode needed?
    ... Databse Manintenance Plan on System Databases faile on Intergrity ... in the single user mode in order to execute CkDBRepair. ... The repair step fails to run and the job reports a failure.... ...
    (microsoft.public.sqlserver.msde)
  • Re: Backup job reported as failed
    ... Perhaps you can find some details if you specify a report file for the plan and investigate that file? ... Tibor Karaszi, SQL Server MVP ... databases in MS SQL Server 2005. ... Deletes old backup files ...
    (microsoft.public.sqlserver.tools)