Monday, February 20, 2012

Master, Model, and Msdb backup

Hi Everyone,
I'm orgainizing the backup maintenance plans for our
company. I create two different plans: one for all
production databases and one for the system databases.
I've got the recovery method set for "Simple" for the
system databases. In the "Optimization" tab in the
maintenance plan, I have just the "Update Statistics" with
a 10% sample. Reorganize index pages doesn't seem like it
would be necessary for these files. Is there anything
else in the optimiztion that I should set? Any
suggestions are appreciated.
Thanks in advance
LarryHi,
For System databases it is not required to reorganise the index pages
frequently becuase the changes are very few. So
you can go ahed with the way you planned.
Only thing is have a look into the maintenance plans and ensure that all
databases are backeup (both user and system) sucessfully daily.
Thanks
Hari
MCDBA
"Larry Morando" <anonymous@.discussions.microsoft.com> wrote in message
news:1c34401c4523d$a7dfef10$a501280a@.phx
.gbl...
> Hi Everyone,
> I'm orgainizing the backup maintenance plans for our
> company. I create two different plans: one for all
> production databases and one for the system databases.
> I've got the recovery method set for "Simple" for the
> system databases. In the "Optimization" tab in the
> maintenance plan, I have just the "Update Statistics" with
> a 10% sample. Reorganize index pages doesn't seem like it
> would be necessary for these files. Is there anything
> else in the optimiztion that I should set? Any
> suggestions are appreciated.
> Thanks in advance
> Larry

No comments:

Post a Comment