Is there a convenient way to manually copy the Log Shipping *.trn files from one SQL 2008 server to
Posted
by Rick
on Server Fault
See other posts from Server Fault
or by Rick
Published on 2010-06-10T16:33:16Z
Indexed on
2010/06/10
16:43 UTC
Read the original article
Hit count: 309
We have a remote SQL 2008 server (ServerB) that needs to keep a warm (15 minute interval is OK) copy of production data (ServerA). ServerA is also SQL 2008. Log Shipping looks like it will do the job. We can only get to the destination ServerB with remote desktop. Is there a way to set this up when we can't get to both servers from one Management Studio? We want to be able to temporarily (until a VPN is setup between our network and the ServerB network) manually export a small .trn file, copy it via remote desktop to ServerB and then manually import those transactions from the .trn file. My supervisor says he saw a post saying this is possible. We were just trying to avoid doing a full database backup and copying that every time. Thanks in advance for any suggestions on this.
© Server Fault or respective owner