Re: Backing up transaction logs
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/31/04
- Next message: Jasper Smith: "Re: Blocking UDP Port 1434"
- Previous message: Bill B: "Interesting issue connecting to Sql server through a firewall.."
- In reply to: Travis: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 30 Mar 2004 23:36:39 +0100
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: Jasper Smith: "Re: Blocking UDP Port 1434"
- Previous message: Bill B: "Interesting issue connecting to Sql server through a firewall.."
- In reply to: Travis: "Re: Backing up transaction logs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
