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: 287

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

Related posts about sql-server-2008

Related posts about Microsoft