MS SQL Server Hosting, questions to ask when researching
If you are a database administrator tasked with the job of researching ms sql server hosting, there are many questions you will want to have answered. Before even doing external research you will need to do internal research. Some questions to ask internal before procedure with a hosted ms sql server would be:
- Are there any internal corporate requirements that would preclude the data being hosted by a third party?
- What about requirements from government or other overseeing organiztions? Especially if the database contains any personal data for something like an accounting firm, laywer, doctor's office, etc.
When you do decide to proceed with looking into a ms sql server hosting option, you will want to gather some internal information:
- How many databases will you be getting hosted?
- How large are those databases?
- What are the backup requirements for the databases?
- Would they work on a shared sql server or would you require a dedicated ms sql server?
The last question on this previous list can greatly impact you decision making. A dedicated ms sql server is going to cost more but should give you better security and performance. If your databases can reside on a server with other database the price should be cheaper but you should really look into the security of your data.
When looking at different ms sql server hosting options keep in mind even more questions:
- What version of MS SQL Server are they using?
- What are the size limitations?
- What about bandwidth limitations?
- How do you remotely administer your databases?
- How can you do an initial load of the database? Doing a big database over the internet may not be feasible.
- Can you request CDs or DVDs of your database backups?
As you do your ms sql server hosting research you'll want to keep all these questions and more in mind.
Yes
No
Flag
Comments
Add a new comment - No HTMLYou must be logged in and verified to post a comment. Please log in or sign up to comment.