Mirrored MSSql servers possible?
Posted on 2013-06-10
I have a Server running SQL Server 2008 R2 that holds a single database that about 150 people access through a custom application. There is a service that runs every Friday that slows access to the database to a crawl while this service is running. What I'd like to do is to deploy a new server that has crazy fast IOPS and processor power, and use the old server as a "mirror" server that this service can use, instead of the new server. I basically want all users to connect to the newer, faster server, and have this service that runs every Friday, do it's thing on the older, mirror server. I've read up on how to do this, but so far, it only looks like you can mirror for fail over. I'm looking for a solution that will allow updates to both the database and log files, on a two way partnership. I'm not sure if this is going to be possible or not.
Thank you for any help.