Solved

Sql server virtualization with centralized client access  setup recommendation

Posted on 2013-01-06
2
394 Views
Last Modified: 2013-02-03
Main office and 5, 6 branch offices. Currently each office has a sql server with pharmacy software installed. Sql server 2000 & server 2003 r2 64 bit runs  on servers. At about 15 users from each office access software using xp clients.

Client needs to virtualize or centralize servers in to main office  & setup clients to access servers from branch offices.
High availability method should include in solution.
How many servers do we buy? , which hardware configuration ?
Vmware or hyper-v ? Which method for high availability?
How is storage consideration?
What are the best ways clients can access software in main office? Clints should print to local pos printers.
What are the other things do we consider in this case?
Your any of suggestions greately appreciated
Thank you.
0
Comment
Question by:upalakshitha
2 Comments
 
LVL 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 38748530
have a read of this recent EE post which debates VMware or Microsoft.

http://www.experts-exchange.com/Software/VMWare/Q_27985921.html

As for Best Practices of SQL on VMware

see here

http://www.vmware.com/files/pdf/sql_server_best_practices_guide.pdf

http://communities.vmware.com/docs/DOC-8964

What's your budget?

(it's a large question, you would probably be better off splitting into several, for more Experts to respond!)
0
 
LVL 13

Author Comment

by:upalakshitha
ID: 38749444
thanks for your valuable input.
still there is no budget. i thought providing full detail will help you to give a solution easily.
ok i will split the question.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A procedure for exporting installed hotfix details of remote computers using powershell
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now