I need sql server up and running nomatter what happens. I need to host a aspnet web application with sql2012. I can rent 2 or 3 web servers. here's what I got:
2 or 3 web servers
esxi for virtualization
windows 2008r2 or windows 2012, enterprise if necessary.
I experimented mirroring and replication. but didn't like active directory requirements very much. first of all configuration is complex. error messages about failover clustering are not explanatory. also as I backup active directory server itself, I would need 4 servers. 2 of them only for AD. it seems waste of resources to me. After 2 weeks of install and test process, active directory is not what I'm looking for.
what I'm asking is, if anyone knows or uses any solution without active directory ? maybe mirroring, maybe replication, maybe always on option. maybe some synch options in web application and sql server itself.
I want to think like that : "something happened to server, no problem. other server is running and I can easily restore backup image or re-install without configuration headaches". let me give an example. at the moment I use virtual machine in vmserver. if something goes wrong I restore backup, copy vmware files from backup and I'm completely SURE that no configuration problems would occur after restore and in 5 minutes I will be up and running. except SQL. I need a hot backup of sql server and it definitely must be another physical server.
any configuration suggestion please ?