Lesson 22. Maintaining the Databases You Build

Just as you need to maintain your SQL Server, you also need to maintain the databases you build. If you fail to properly maintain your databases, not only can performance be affected, you can also lose your data. This lesson explains:

Image How to back up your databases

Image How to restore your databases

Image How to utilize the Database Tuning Advisor

How to create and work with maintenance plans

Backing Up Your ...

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.