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:
How to back up your databases
How to restore your databases
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.