Re: Backing up transaction logs
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/20/05
- Next message: Joe K.: "MSDTC Security"
- Previous message: Sue Hoegemeier: "Re: Accidentally dropped DBO from database"
- In reply to: Tim: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 20 Jan 2005 10:51:56 -0700
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:
>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)).
>> >> >>>
>> >> >>>
>> >> >>>.
>> >> >>>
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
- Next message: Joe K.: "MSDTC Security"
- Previous message: Sue Hoegemeier: "Re: Accidentally dropped DBO from database"
- In reply to: Tim: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
