Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS SQL Server 2008 Administration


Our MS SQL Server 2008 Administration test measures your knowledge of administering Structured Query Language Server 2008 databases. Designed for experienced administrators, but an average performer in this role should pass this test. This test covers the following topics: Administrative Tools and Utilities, Architecture, Backup and Restore, High Availability Functions, Index Management, Replication, Security, and Troubleshooting.

This test is associated with a Job Role. Please visit the Job Role Center for more details.


Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Administrative Tools and Utilities
CMD Utility
SQL Server Configuration Manager
SQL Server Management Studio
Data Types
Online Database Maintenance Operations
Transaction Isolation Levels
Backup and Restore
Master Database Recovery
Transparent Data Encryption
High Availability Functions
Database Mirroring
Log Shipping
Index Management
Index Management Commands
Partitioned Indexes
XML Indexes
Replication Monitor
Replication Topology
Replication Types
Database Users and Roles
Principals, Securables and Permissions
Server Logins and Role
Extended Events
Performance Data Collector
Performance Monitor
Query Performance Tuning
SQL Profiler