Backing up transaction logs

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)).Have a look at these. I tend to set job owner to sa to avoid this
http://support.microsoft.com/defaul...3&Product=sql2k
http://support.microsoft.com/defaul...4&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)).|||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...
2000.
data
figure
enterprise
not
find
for
Plan2'
group/user 'xxxdomainxxx\Administrator'.
>
>.
>|||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.
>
>avoid this
>us;241643&Product=sql2k
>us;834124&Product=sql2k
>message
>2000.
>data
>figure
>enterprise
>not
>find
>for
>Plan2'
>group/user 'xxxdomainxxx\Administrator'.|||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:
>
for
in
this
Failed -
information
>.
>|||If you specified a report you should see more error details in there. From
the sound of it you may have specified a single plan for all databases and
included log backups. You can't do log backups of master and SQLAgent will
set msdb to simple when it starts if it's not already so you can't really do
if for msdb either. I'd usggest 1 plan for system databases (full backups
only) , 1 for user databases in simple mode and one for databases in full
recovery mode with log backups.
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:131a101c4169e$5a5e9b90$a601280a@.phx
.gbl...
> 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!
>
> plans,
> the
> for
> in
> this
> Failed -
> information|||I got it working with no errors! I did like you said and
created 3 seperate plans. Thanks so much for your help.

>--Original Message--
>If you specified a report you should see more error
details in there. From
>the sound of it you may have specified a single plan for
all databases and
>included log backups. You can't do log backups of master
and SQLAgent will
>set msdb to simple when it starts if it's not already so
you can't really do
>if for msdb either. I'd usggest 1 plan for system
databases (full backups
>only) , 1 for user databases in simple mode and one for
databases in full
>recovery mode with log backups.
>--
>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:131a101c4169e$5a5e9b90$a601280a@.phx
.gbl...
include
resolve
on
Plan
like
in
clicked
Failed -
to
scid=kb;en-
scid=kb;en-
SQL
was
does
can't
Job
Log
>
>.
>|||The error that I am having(which is along the same vane) is occurring
when trying to delete old Tlog backup files.
Any ideas how to fix this one?
Travis wrote:[vbcol=seagreen]
> I got it working with no errors! I did like you said and
> created 3 seperate plans. Thanks so much for your help.
>
> details in there. From
> all databases and
> and SQLAgent will
> you can't really do
> databases (full backups
> databases in full
> message
> include
> resolve
> on
> Plan
> like
> in
> clicked
> Failed -
> to
> scid=kb;en-
> scid=kb;en-
> SQL
> was
> does
> can't
> Job
> Log|||There are a couple of completely different error messages
posted in this thread. Could you please post exactly what
problems you are having and the exact error message?
For example, is this an error you get with a maintenance
plan, please post that and some details about the task in
the maintenance plan. If you are receiving errors when a
maintenance plan runs, get the details of the error from the
maintenance plan history and post those.
It's hard to tell from piggy backing off this thread what
your specific issue is. If you could post more details,
someone should be able to help you out.
Thanks -
-Sue
On 20 Jan 2005 07:10:19 -0800, "Tim"
<Timothy.Juarez@.Ipaper.com> wrote:
[vbcol=seagreen]
>The error that I am having(which is along the same vane) is occurring
>when trying to delete old Tlog backup files.
>
>Any ideas how to fix this one?
>
>Travis wrote: