Upgrade from MS Access to SQL Server
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
Start the conversation
0 comments