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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.