I have two instances of SQL Server 2005 STANDARD edition, Server A in New York and Server B in California.
Server A has a large database; for DR/BCP purposes, I would like to use Log Shipping to keep a warm backup on Server B.
Unfortunately, the transaction logs are too large (over 10GB across a WAN =( ). Before I invest in a third party product that deals with this issue, could I do something like this:
Disable the copy job on Server B. Backups are still created on Server A, but are not automatically moved to Server B.
Create a scheduled task to compress all backed up logs on Server A (using a tool like 7zip or WinZip), and dump them on Server B where the restore job expects them (and unzipping, of course).
Allow the restore job on Server B to work as normal.
Is this a naive or workable solution?
If we had enterprise edition, I would use asynchronous database mirroring; or if we had 2008 Enterprise edition I would look into the built in compression.