O'Reilly logo

MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 by Thomas Moore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required