?
Solved

Sql server virtualization with centralized client access  setup recommendation

Posted on 2013-01-06
2
Medium Priority
?
399 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 123

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A look into Log Analysis and Effective Critical Alerting.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

765 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