Best way to keep a database synched with a server that is outside the firewall

Hi,
We have two servers, one inside the firewall and one outside and need to
keep them synched up on a daily basis. Short of doing full backup and
restore, what is best solution?
Thanks.<a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> Hi,
> We have two servers, one inside the firewall and one outside and need to
> keep them synched up on a daily basis. Short of doing full backup and
> restore, what is best solution?
Depends on what you need.
If you need read-only, I'd go with either replication or log-shipping.
With log-shipping just create a stand-by file between loading each log file.
You'll be able to read from the database.
Shipping just the log files should be smaller than a full-backup and
restore.
If you go with replication, you're probably going to have to open up your
firewall a bit more and be a bit more careful about security.
But then you won't get kicked out each time changes are made on the outside
server.
> Thanks.
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Thank for the response. Can I set up log shipping or replication when the
primary and secondary server can not even see each other? The only port
open on the primary server's firewall is 80. Thanks again.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
> <a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> We have two servers, one inside the firewall and one outside and need to
>> keep them synched up on a daily basis. Short of doing full backup and
>> restore, what is best solution?
> Depends on what you need.
> If you need read-only, I'd go with either replication or log-shipping.
> With log-shipping just create a stand-by file between loading each log
> file. You'll be able to read from the database.
> Shipping just the log files should be smaller than a full-backup and
> restore.
> If you go with replication, you're probably going to have to open up your
> firewall a bit more and be a bit more careful about security.
> But then you won't get kicked out each time changes are made on the
> outside server.
>
>> Thanks.
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||<a> wrote in message news:uM2c7hucHHA.4624@.TK2MSFTNGP03.phx.gbl...
> Thank for the response. Can I set up log shipping or replication when the
> primary and secondary server can not even see each other? The only port
> open on the primary server's firewall is 80. Thanks again.
Hmm... not out of the box.
Realistically you probably could do this through port 80, but it would be a
mess.
One possible way, though a bit more complicated and error prone, would be to
log-ship the files via FTP.
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
>> <a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> We have two servers, one inside the firewall and one outside and need to
>> keep them synched up on a daily basis. Short of doing full backup and
>> restore, what is best solution?
>> Depends on what you need.
>> If you need read-only, I'd go with either replication or log-shipping.
>> With log-shipping just create a stand-by file between loading each log
>> file. You'll be able to read from the database.
>> Shipping just the log files should be smaller than a full-backup and
>> restore.
>> If you go with replication, you're probably going to have to open up your
>> firewall a bit more and be a bit more careful about security.
>> But then you won't get kicked out each time changes are made on the
>> outside server.
>>
>> Thanks.
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html