Maintenance Plans seems to be some what popular with novice DBAs simply because you don’t have to think much to configure a Maintenance Plan.
However, today I came across with two “interesting” cases. I will explain one of them today.
This is one of them.
According to this plan, it take a full backup and just after the full backup , it takes a differential backup!!!
Differential backup will contain all the modified data pages after the last full backup. Since these plans are running on mid-night, it is highly unlikely, you get any modifications after the full backup. This means that you should have a differential backup for a different plan.
No comments:
Post a Comment