Articles
Windows FAQ
Making your network more secure - Use a firewall - Windows Vista...
Making your network more secure - Run antivirus software on each...
User accounts FAQ - An unidentified program wants access to your...
Making your network more secure - General network security recom...
What is User Account Control? - Windows Vista Security - User ac...
Who's Online
15 user(s) are online (4 user(s) are browsing Forum)

Members: 0
Guests: 15

more...

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
Offline
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 the post to other applications 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.

[Advanced Search]


Copyright © 2009 FYIcenter.com
Search
Main Menu
Login
Username:

Password:


Lost Password?

Register now!