Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Windows Server 2008R2 Server, running SQL Server 2008R2 SP2. The server currently only does a full backup once daily. The server's operational hours are between 8am and 5pm. The server's new RTO is 0mins and it's RPO is 0mins during operational hours. What is the best option in achieving this? I have currently thought of an AlwaysOn Availability Cluster. As for backups I have thought of Transactional Log backups every 15mins, Differential backups every 2 hours, and keeping the Full backup every day. Is my plan sufficient?

Also with an AlwaysOn Availability Cluster, do I just need 1 additional server to be a replica or do I really need a Primary Replica and Secondary Replica? (still very confused about AlwaysOn...)

If I implement AlwaysOn, do I really need to backup each server?

If I implement AlwaysOn, do I really need to use a SAN?

Are there any performance impacts doing backups doing business hours?

share|improve this question
Always On is available on SQL Server 2012... Do you have any plan to upgrade soon? – KookieMonster Nov 28 '13 at 8:50
Yes I plan to upgrade to SQL 2012. – user2655895 Nov 28 '13 at 10:46

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.