Due to growing data dependency of organizations, high availability is imperative. While implementing any configuration for high availability follow following base lines.
- Physically protect your SQL Servers from unauthorized users.
- Physically document all of your SQL Server instances. Incorporate effective change management.
- Always use a RAIDed array or SAN for storing your data.
- Use SQL Server clustering, database mirroring, or log shipping to provide extra fault tolerance.
- Replication is not an effective means to protect your data.
- Ensure that your entire IT infrastructure is redundant. It is only as strong as its weakest link.
- Always use server-class hardware, and standardize on the same hardware as much as possible.
- Use hardware and software monitoring tools so you can quickly become aware of when problems first arise.
- After testing, apply all new service packs and hot fixes to the OS and SQL Server.
- Cross-train staff so that there are multiple people who are able to deal with virtually any problem or issue.
Chosen from SQL Server DBA best practices By Brad M.mcGehee