Solved

SQL 2008 High availability ?

Posted on 2011-02-15
4
285 Views
Last Modified: 2012-05-11
Hello gurus,

I have an ERP solution that runs on SQL 2008 R2
there is a folder (and subfolders) where the application is (exe...dlls...etc..) and a folder where the Databases are.

Now I need this application to be high availibility..., so I set up the same thing on another server and
I want to set up a mirroring between the 2 servers.
now my problem is as follows:
1-How to make this application high available and fail over automatically ?
2-would I need a witness or no need ? ( both servers are on 1 LAN)

thanks
0
Comment
Question by:ammounpierre
  • 2
4 Comments
 
LVL 29

Expert Comment

by:mass2612
ID: 34895863
Hi,

With regards to making the application HA you will need to speak to the app vendor. I would suggest possibly load balancers or a cluster for the app servers if the software is compatible. What's the ERP software?

However in regards to the SQL database it really depends on how highly available you need it to be or how much you can afford.

You could setup synchronous DB mirroring between 2 SQL servers at the site and if you use a witness server it enables automatic failover. You could then also log ship from the principal DB to a secondary site.
0
 

Author Comment

by:ammounpierre
ID: 34895891
mass2612 , thanks for the info , but the problem really is not there..

I have on my desktop a shortcut to the application that is from server1 which is \\server1\apps\myapp.exe

now on this shortcut there is in the connection string the partner parameter with its name (server2)

but the problem is that if server1 goes down..then myapp.exe is not available anymore... so I need to

switch to \\server2\apps\myapp.exe and THIS IS THE PB.

in case server1 is down... the user would be down.. and needs to re-connect to Server2\apps\myapp.exe

right ?
0
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 250 total points
ID: 34895930
With the fact that you are doing this through a file share there is no way round this without installing this on every users PC.

If you decide to go down the route of install on users PC, using something like SCCM would this much easier.

0
 
LVL 29

Accepted Solution

by:
mass2612 earned 250 total points
ID: 34895960
Since you ask this in the SQL section and mention it I thought you were concerned about SQL HA. Sorry. You could setup the servers in a file share cluster and have the users connecting to the cluster share name rather than the physical host name of the nodes in the cluster.

Or you could use DNS forwarding and connect to the DNS alias that then points to server1 or server2 depending on the situation.

For example: -

DNS alias = erpapp.yourdomain.com that points to server1 and then during a failure you update the alias to point to server2.

Users then map to \\erpapp
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
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 walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

832 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