[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sql server virtualization with centralized client access  setup recommendation

Posted on 2013-01-06
2
Medium Priority
?
402 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 124

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
August and September have been big months for VMware—from VMworld last month to our new Course of the Month in VMware Professional - Data Center Virtualization. We reached out to Andrew Hancock, resident VMware vExpert, to have a more in-depth discu…
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…
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

834 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