I was once told that I was not to use the GUI to setup a maintenance plan.What the person said was that I needed to setup a different plan to do each tab of the GUI instead of going through the tabs and making sure the times do not overlap.
Has anyone ever heard of this or is this an old wise tale told by only one person?
I am using version 8 of SQL on XP machines with 8 connections to that database and need to back up the database, clean it up and everything the GUI has, so teach me the correct ways and tell me why, thanks!
It's basically a tradeoff of ease of use vs level of control, and that last increment of performance.
The GUI will produce a workable maintenance plan to do what you tell it to.
It will not be optimized to your particular situation.
So, by taking more control and scripting the actions you can arrive at a configuration which is more tuned to your environment, and therefore more efficient.
On the other hand, you can use the GUI and be done with it.
You need to make those tradeoffs for your own situation.
No comments:
Post a Comment