We are having 2 SQL Server 2005 EE databases(on Windows 2003 EE) of different sizes ( 60G and 1.5TB(includes BLOBS)). We are planning for a DR solution for this database.
This is only for DR and not for load balancing purpose, the secondary database would be only used when primary fails or during maintenance of primary database. The amount of redo generated for 1Tb database would be 1G per day and for the other smaller database
it would be 500M per day. The network would be able to handle bandwidth upto 1.5Mbps. We dont have a shared location between these two servers for security purposes. We want the DR to be exact copy of the primary and in case of the DR, the secondary would
become the primary and the primary database needs to take on the secondary role without much reconfiguration(not looking for a complete restore as this may slow things). DR would be initated manually so wouldn't want that to happen automatically.
I did go through Peer to peer transactional replication and SQL Mirroring but not sure what would be the best fit here?
Any suggestions? I am an Oracle DBA with little knowledge on SQL Server, so any help would be very much appreciated.
Will replication/mirroring be possible between two different version?
View Complete Post