Good morning all I have been researching various methods of SQL Server recovery options.
The scenario is simple and I want the same solution. I have 2 SQL Server databases on separate machines at separate locations and they have access to each other via a VPN.
The Primary server in this instance is on Win Server 2003 and running SQL Server 2005, the swanky new secondary server is Win Server 2008 R2 and SQL Server 2008.
Regardless of the awesome inconsistencies between the two we still want the secondary server to be up to date and available.
I looked at transaction log shipping and have been for a couple of days but I've come to the realisation that the database is only ready when I apply transaction logs by hand and this is not what we want.
The database should be no more than 24 hours out of date. I'm going to end up with full back up and restores but before we set this up via a script what other options are there.
I looked at mirroring but this doesn't work between varying SQL Server versions.
I looked at replication but it is not viable to change the tables on the database to support replication either.
Any options? :)