Re: Backing up transaction logs
From: Tim (Timothy.Juarez_at_Ipaper.com)
Date: 01/20/05
- Previous message: Ken Schaefer: "Re: running out of ports"
- Next in thread: Sue Hoegemeier: "Re: Backing up transaction logs"
- Reply: Sue Hoegemeier: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: 20 Jan 2005 07:10:19 -0800
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:
> 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...
> >> 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)).
> >> >>>
> >> >>>
> >> >>>.
> >> >>>
> >> >
> >> >.
> >> >
> >
> >
> >.
> >
- Previous message: Ken Schaefer: "Re: running out of ports"
- Next in thread: Sue Hoegemeier: "Re: Backing up transaction logs"
- Reply: Sue Hoegemeier: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
