ammounpierre
asked on
SQL 2008 High availability ?
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
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
ASKER
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 ?
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 ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.