Re: Backing up transaction logs

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

Date: Tue, 30 Mar 2004 12:41:21 -0800

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: Backing up transaction logs gives poor performance.
    ... I cannot get the SQL Maintenance plan to save the transaction log files any where over the network. ... Tibor Karaszi, SQL Server MVP ... While there (the maintenance plan dialog box), I noticed that I have the verify log backup option ticked. ... Transaction log backup files from this database are typically about 20MB while the application is busy. ...
    (microsoft.public.sqlserver.setup)
  • Re: tlog fail in EM but files written
    ... SQL Server MVP ... "Rohans" wrote in message ... > My maintenance plan does a transaction log every 10 minutes to a UNC path ...
    (microsoft.public.sqlserver.server)
  • Re: Backing up transaction logs
    ... I tend to set job owner to sa to avoid this ... Jasper Smith (SQL Server MVP) ... > base as well as the transaction log. ... > Backup Job for DB Maintenance Plan 'DB Maintenance Plan2' ...
    (microsoft.public.sqlserver.security)
  • Backup question
    ... Using sql server 2000... ... Does running a backup using a DB Maintenance plan cause the transaction log ...
    (microsoft.public.sqlserver)
  • Re: Transaction log and tempdb
    ... - Is it possible to reduce the size of the transaction log fil during ... an execution? ... It sounds as if you are the database is in full recovery. ... If I execute that script sql server seems ...
    (comp.databases.ms-sqlserver)