SQL 2008 High availability ?
Posted on 2011-02-15
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)