Maintenance Plans

Maintenance plans…When I was working as a systems admin, I was tasked with setting up backups and their schedules; this also included the SQL databases. Setting up maintenance plans was my “foot-in-the-door” for getting to know more about SQL. It was first isolated to just backups and as I started learning more and more, I was setting up maintenance plans to re-index databases, update stats, etc…and knowing what each task did. I also sometimes grabbed the code from the maintenance plans and placed them in a custom job.

This next chapter by Tibor Karaszi is an awesome read if you are new to SQL maintenance plans. He does into detail the functionalities that the maintenance plan tasks have and when they are typically used for. He also writes that some folks don’t even use maintenance plans. I can see that happening when you really want to customize the job.

This is a chapter you can’t miss to read. You may look at the title of the chapter and say “Oh I know too much about maintenance plans already”, even if you do, there is nothing wrong with refreshing your mind. You may even find something out that you didn’t know existed in maintenance plans.

Thank you for reading this week. Have a good one!


0 Responses to “Maintenance Plans”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 11 other followers