MS SQL Server 2005 Administration

Test Outline

Administrative Tools and Utilities
CMD Utility
Installation
Microsoft SQL Server Management Studio
SQL Server Configuration Manager
Architecture
CLR
Data Types
Online Database Maintenance Operations
Backup and Restore
Backup
Master Database Recovery
Restore
High Availability Functions
Clustering
Database Mirroring
Log Shipping
Index Management
Index Management Commands
Partitioned Indexes
XML Indexes
Replication
Publisher, Distributer and Subscriber
Replication Monitor
Transactional, Merge and Snapshot Replication
Security
Password Policy
Principals, Securables and Permissions
Schema

 

Go Back