First, which version of SQL Server do we need (Standard or Enterprise) and what would be the best (cheapest) licensing format? The application will use Terminal server for some of the heavier maintenance forms and IIS for the Web forms (time entry and reporting).
Second, this is a live critical application where data loss and downtime is unacceptable. I am also interested in how to deal with a power outage or the possibility of the network going down where the main server is located. I don't have any SQL background, but I do have experience with other databases (no enterprise experience), and some programming experience.
Any help will be welcomed.
Your second issue is one of availability. The good news is that most of the availability features you're probably interested do ship with Standard Edition. Based on what you've told me, I'd encourage you to consider setting up a cluster. There's lots of documentation on clustering in the SQL Server books on-line.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Installation
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain. Continue Reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline. Continue Reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.