Review in .NET

Encode PDF417 in .NET Review

To help you successfully master the exam objectives presented in this chapter, complete the following practice tasks.

Create and test a backup strategy for your databases that includes full, differential, and transaction log backups. Create and test a backup strategy for your databases that includes filegroup, differential, and transaction log backups. Create a database that contains both read-only and read-write filegroups, and back up only the read-write filegroups. Change the backup strategies created in Practices 1 and 2 to include duplicates of each backup by using the new mirrored backup capability.

Test your backups created in Backing Up a Database Practice 1 by restoring them. Test your backups created in Backing Up a Database Practice 2 by restoring them. Test your backups created in Backing Up a Database Practice 3 by restoring them. Test your backups created in Backing Up a Database Practice 4 by restoring from a mirror. Restore a single filegroup (not the primary filegroup) into a database and then observe that any objects in filegroups not being restored can be accessed. Restore a page into a database to simulate a corrupted page that needs to be restored. Shut down SQL Server, delete the master.mdf, and then restore the master database and verify that all databases are intact and accessible. (You are backing up your master database, right ) Create a Database Snapshot against a database. Make some changes. Restore the database by using the Database Snapshot and verify that your changes no longer exist in the database.

Move a database by using the detach/attach method. Determine which other objects also need to be moved to make the database fully accessible to applications. Move a database by using the Copy Database Wizard. Select the SMO option and observe the move process. Determine which other objects also need to be moved to make the database fully accessible to applications.

The practice tests on this book s companion CD offer many options. For example, you can test yourself on just the content covered in this chapter, or you can test yourself on all the 70-431 certification exam content. You can set up the test so that it closely simulates the experience of taking a certification exam, or you can set it up in study mode so that you can look at the correct answers and explanations after you answer each question.

For details about all the practice test options available, see the section titled How to Use the Practice Tests in this book s Introduction.

12

Maintaining your databases is often a complex and time-consuming task that involves a multitude of steps you need to perform on a periodic basis. Database administrators (DBAs) often perform their maintenance tasks by using the Maintenance Plan Wizard or the Microsoft SQL Server 2005 main graphical user interface (GUI): SQL Server Management Studio (SSMS). However, this chapter will show you how to accomplish the common maintenance tasks of managing index fragmentation and statistics, shrinking databases, and performing integrity checks by using the power of Transact-SQL.

Exam objectives in this chapter:

Manage index fragmentation. Manage statistics. Shrink files. Perform database integrity checks by using DBCC CHECKDB.

Lessons in this chapter:

Lesson 1: Managing Index Fragmentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449 Lesson 2: Managing Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 457 Lesson 3: Shrinking Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463 Lesson 4: Using DBCC CHECKDB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469