For all of you running a MS SQL DB server backend:

How do you provide fault tolerance? Backup strategies? Etc.

Just trying to plan a deployment and I have folks asking me about such things.
Thanks.