Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL
MSDN Fourms
Fort Worth SSUG
Oklahoma City SSDG
Resume
Champion Valley Pens

70-026 SQL Server Administration 1 2 3

Replication
The replication questions are relatively straightforward.
1. Which replication model to apply given a specific business scenario.
2. The role of the publisher and the subscriber
3. The distribution database
4. How to clean out and reset replication in the event of an error
5. The main tables involved in replication, which database they reside in, and what information they contain

BCP
What BCP is, it's function in your environment, and the syntax for the BCP command

SQL Mail
The SQL mail questions will test your knowledge of the mail sending and processing extended stored procedures and their syntax.

Client libraries
The questions concerning client libraries are probably the most difficult ones on the entire exam. These will test your ability to deploy SQL Server based applications in virtually every environment possible. Do not expect to find questions on how to set up simple connections. You'll need to understand the following
1. Setting up a named pipes connection and testing it  (makepipe and readpipe)
2. The multi-protocol library and data encryption
3. Configuring client libraries on a Macintosh client
4. Configuring client libraries within a Banyan Vines environment

General
1. Placing tempdb in RAM and under what conditions you would do this
2. Mapping invalid characters
3. Event logging
4. Error logs
5. Adding remote servers
6. Changing local server name
7. Killing processes

70-026 SQL Server Administration 1 2 3

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.