Chapter 6. Database Maintenance

Terms you’ll need to understand:

  • ✓ SQL Server Agent

  • ✓ Job

  • ✓ BACKUP command

  • ✓ RESTORE command

  • ✓ Database snapshot

  • ✓ Recovery model

  • ✓ The INIT and NOINIT commands

  • ✓ The SKIP and NOSKIP commands

  • ✓ The FORMAT and NOFORMAT commands

  • ✓ Scheduling

  • ✓ The STOPAT option

  • ✓ The HEADERONLY, VERIFYONLY, and LABELONLY options

Techniques you’ll need to master:

  • ✓ Viewing job details and history

  • ✓ Using queries against the msdb system database

  • ✓ Backing up and restoring databases and logs

  • ✓ Utilizing database snapshots

  • ✓ Implementing recovery modes and recovery options

  • ✓ Scheduling maintenance

Database and server maintenance are ongoing in a production environment. As a database administrator or other IT manager, you must perform numerous maintenance ...

Get MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 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.

Start your free trial