sqlsql-server-2008backupdisaster-recoverylog-shipping

sql server log shipping to remote server in different network


I need to setup a Disaster Recovery. I need to setup Log shipping to remote server not in same network. I can transfer log shipping trc files to remote machine through internet. But how to import trc files to secondary server. Actually i am trying to logship to a remote server for backup copy of database.


Solution

  • You can restore the .trn files using RESTORE LOG (WITH NORECOVERY).

    You need to do a full backup & restore (WITH NORECOVERY) of the database before you can restore any transaction logs.

    If you can setup a VPN, it's best to let SQLServer do the whole backup & restore & verify - the copy phase is pretty easy to override - just write your own copy SQLAgent job & disable the copy job that SQL setup for you.