Re: Backing up transaction logs

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 19:43:24 +0100

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
    ... DB Maintenance Plan 'DB Maintenance Plan1'' ... I tend to set job owner to sa to ... >Jasper Smith (SQL Server MVP) ... >> base as well as the transaction log. ...
    (microsoft.public.sqlserver.security)
  • Re: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesnt WORK
    ... Maintenance Plan in SQL Server 2005. ... Microsoft CSS Online Newsgroup Support ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • RE: Maintenance Plan
    ... The best way to get sarted with Maint Wizard (or any of these admin tasks) ... Database Maintenance on SQL Server 7.0/2000 ... Troubleshooting Database Maintenance Plan Failures ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot create a Manintenance Plan in SQL Server 2005
    ... > I'm using the Maintenance Plan Wizzard to set up a Back Up Database ... Do you have SSIS (SQL Server Integration Services) Installed? ... execute maintenance plans, you must install SSIS." ...
    (microsoft.public.sqlserver.setup)
  • 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)