We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial backup/copy would tie up bandwidth for days, if not weeks, which we would like to avoid if at all possible.
We have made a copy (now a few days old) by backing up the primary database to a hard disk and physically taking the hard disk to the secondary machine and restoring the database there.
Primary and Secondary Servers are in different geographical locations. Primary Server is on SQL Server 2008, Secondary on 2008 R2 (Don't ask why!)
There seems to be no way we can find to get log shipping (or mirroring) to work without starting the backup/copy/restore process from scratch.
Any ideas/solutions would be greatly appreciated.