|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DB Maintenance Planner - Jobs not runningI set up 12 DB maintenance jobs on 3 separate DB's through the DB Maintenance
Planner - each job has a daily time to run. All the jobs ran last night EXCEPT: MSDB db trans log backup / MSDB db Integrity Checks Master db trans log backup / Master db Integrity Checks I am assuming that it is not necessary to run these jobs and I should delete them. Am I right? Thanks in advance. bill Hi,
I agree; Since there is no much data changes, it is not required to perform transaction log backup on MSDB and Master databases. Thanks Hari Show quote "WCM" <W**@discussions.microsoft.com> wrote in message news:CC358189-EEC8-4FF3-91B0-F91972909ABE@microsoft.com... >I set up 12 DB maintenance jobs on 3 separate DB's through the DB >Maintenance > Planner - each job has a daily time to run. > > All the jobs ran last night EXCEPT: > MSDB db trans log backup / MSDB db Integrity Checks > Master db trans log backup / Master db Integrity Checks > > I am assuming that it is not necessary to run these jobs and I should > delete > them. Am I right? > > Thanks in advance. > > bill But you definitely want to do integrity checks on these databases... :-)
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Hari Prasad" <hari_prasa***@hotmail.com> wrote in message news:%233r43%23CFHHA.4580@TK2MSFTNGP05.phx.gbl... > Hi, > > I agree; Since there is no much data changes, it is not required to perform transaction log backup > on MSDB and Master databases. > > Thanks > Hari > > "WCM" <W**@discussions.microsoft.com> wrote in message > news:CC358189-EEC8-4FF3-91B0-F91972909ABE@microsoft.com... >>I set up 12 DB maintenance jobs on 3 separate DB's through the DB Maintenance >> Planner - each job has a daily time to run. >> >> All the jobs ran last night EXCEPT: >> MSDB db trans log backup / MSDB db Integrity Checks >> Master db trans log backup / Master db Integrity Checks >> >> I am assuming that it is not necessary to run these jobs and I should delete >> them. Am I right? >> >> Thanks in advance. >> >> bill > > Thank you, Tibor. I was concerned about those particular job failures. I
will set them up again and see if they work. If not, I am told that setting up a new user (same username in both Windows and Sql Server) with permission to run jobs may be necessary. Thanks again. Show quote "Tibor Karaszi" wrote: > But you definitely want to do integrity checks on these databases... :-) > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Hari Prasad" <hari_prasa***@hotmail.com> wrote in message > news:%233r43%23CFHHA.4580@TK2MSFTNGP05.phx.gbl... > > Hi, > > > > I agree; Since there is no much data changes, it is not required to perform transaction log backup > > on MSDB and Master databases. > > > > Thanks > > Hari > > > > "WCM" <W**@discussions.microsoft.com> wrote in message > > news:CC358189-EEC8-4FF3-91B0-F91972909ABE@microsoft.com... > >>I set up 12 DB maintenance jobs on 3 separate DB's through the DB Maintenance > >> Planner - each job has a daily time to run. > >> > >> All the jobs ran last night EXCEPT: > >> MSDB db trans log backup / MSDB db Integrity Checks > >> Master db trans log backup / Master db Integrity Checks > >> > >> I am assuming that it is not necessary to run these jobs and I should delete > >> them. Am I right? > >> > >> Thanks in advance. > >> > >> bill > > > > > > Hari, thank you for the confirmation. b.
Show quote "Hari Prasad" wrote: > Hi, > > I agree; Since there is no much data changes, it is not required to perform > transaction log backup on MSDB and Master databases. > > Thanks > Hari > > "WCM" <W**@discussions.microsoft.com> wrote in message > news:CC358189-EEC8-4FF3-91B0-F91972909ABE@microsoft.com... > >I set up 12 DB maintenance jobs on 3 separate DB's through the DB > >Maintenance > > Planner - each job has a daily time to run. > > > > All the jobs ran last night EXCEPT: > > MSDB db trans log backup / MSDB db Integrity Checks > > Master db trans log backup / Master db Integrity Checks > > > > I am assuming that it is not necessary to run these jobs and I should > > delete > > them. Am I right? > > > > Thanks in advance. > > > > bill > > >  |
|||||||||||||||||||||||
Other interesting topics