Browsing this Thread:
3 Anonymous Users
DBA Checklist - General High Availability |
||
|---|---|---|
|
Just can't stay away
![]()
Joined:
2007/11/4 20:11 Group:
Registered Users Posts:
101
Level : 9; EXP : 5
HP : 0 / 201 MP : 33 / 1211 ![]() |
DBA Checklist - General High Availability
1. Physically protect your SQL Servers from unauthorized users. 2. Physically document all of your SQL Server instances. Incorporate effective change management. 3. Always use a RAIDed array or SAN for storing your data. 4. Use SQL Server clustering, database mirroring, or log shipping to provide extra fault tolerance. 5. Replication is not an effective means to protect your data. 6. Ensure that your entire IT infrastructure is redundant. It is only as strong as its weakest link. 7. Always use server-class hardware, and standardize on the same hardware as much as possible. 8. Use hardware and software monitoring tools so you can quickly become aware of when problems first arise. 9. After testing, apply all new service packs and hot fixes to the OS and SQL Server. 10. Cross-train staff so that there are multiple people who are able to deal with virtually any problem or issue.
Posted on: 10/29 13:09
|
|
Transfer
|
||
You can view topic.
You cannot start a new topic.
You cannot reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You cannot vote in polls.
You cannot attach files to posts.
You cannot post without approval.



Transfer
