SQL Mirroring Options
Please Login to Remove!
I just build a BES server for our company with HA Failover capability. I was advised to simply use the SQL 2005 Express that came with the BESv5 package (this was all new to me). I have successfully set the server up and created a failover server as well. All works great.
I was thinking about disaster recovery options, and wanted any recommendations that since SQL Server 2005 Express does not support database mirroring, what others are doing to in reference to that?
I ultimately wanted database mirroring setup from the beginning but they wanted to minimize costs. So now I just have a automatic backup of the database occuring every night but I would feel more comfortable having the system access the mirrored database automatically if something was to happen.
Is this possible at this point?
TIA
|