23
Jul
10

Maintenance Plans

From the way I see it… I think this is the most important chapter in the book.

From Day 1 of being responsible for a database you as a DBA need to know how to back up your database, and how to restore it. But the tasks don’t stop there. Your job is to make sure the database is online and the users can use it. This means taking care of all the aspects of the database. The same way that Tibor Karaszi points out that you have to maintain your car or your house, you must maintain your database.

If your new to SQL Server stick to Tibor’s advice. A plan will be created that you can use long term. As you feel more comfortable start working with other aspects of the chapter and Maintenance Plans, look at the schedules or handling your indexes a little differently. I think I jumped for joy when I saw in the Maintenance Plan chapter the best advice on shrinking your database. Another well done chapter for one of the best SQL Books I have read.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s


Chapters

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

Join 13 other followers