Saturday, February 25, 2012

DB Maintenance Planner - Jobs not running

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
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" <WCM@.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.
"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" <WCM@.discussions.microsoft.com> wrote in message
> news:CC358189-EEC8-4FF3-91B0-F91972909ABE@.microsoft.com...
>
>
|||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.
"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_prasad_k@.hotmail.com> wrote in message
> news:%233r43%23CFHHA.4580@.TK2MSFTNGP05.phx.gbl...
>

No comments:

Post a Comment