Company X
SQL Server Technical Documentation

Quick Reference for Support Questions              1

Our SQL Servers & Their Service Levels              3

Differences Between Tiers              3

Database Server Restrictions              6

Things That Require DBA Signoff              6

Things Not Available on Production Servers              7

Things Not Available On Any Server              8

Load Testing              10

Backups & Restores              11

Network Backups              11

Restoring Databases              12

High Availability & Disaster Recovery              13

Clustering              13

Database Mirroring              13

Change Control              17

Deployment Practices              17

Maintenance Windows & Patches              19

QA & Development Servers              19

Mission-Critical & Production Servers              19

When to Get Help from the DBA              20

SQL Coding Standards              21

Design for Database Mirroring              21

Table Design              21

Stored Procedures & Functions              22

SQL Server Setup Standards              23

SQL Server 2005 Setup Checklist              23

Quick Reference for Support Questions

If you need to do any of these things:

·         Create a database

·         Add or change security permissions

·         Install software on a database server

·         Back up or restore a database

Then create a help desk ticket for Windows Systems.

In an emergency, contact the following people in this order:

·         Lead DBA – Jane Doe – desk 281-555-1213, cell 281-555-9357

·         Junior DBA – John Smith – desk 281-555-1215, cell 281-555-7725

·         IT Manager – Fred Adams – desk 281-555-1209, cell 281-555-0395

·         Company Help Desk – 1-800-555-1000.  Ask to open a Severity 1 help desk ticket, and they can reach the next available member of the IT team.

What’s In This Document?

This document is for technical staff (developers & network admins) that need info about our SQL Server 2005 database servers.

Our SQL Servers & Their Service Levels

We have four sets of SQL Servers for different uses.  The differences between the categories are shown below: