[olug] SQL transaction log shipping

[Terry]

Reading this makes me think about high availability and data
consistency.  I would also investigate what would happen if you were
to miss part of your transaction logs.  Sending important transaction
logs offsite via a network can be kind of scary.  That is probably why
I would elect to write them to tape locally to be shipped offsite. 
Just a thought.  :)


On Tue, 31 Aug 2004 09:17:45 -0500, Rod Hurley <rhurley at tmvgas.com> wrote:
> This is more of a DBA question and not so much a Linux one, but I could
> use some advice.  I will be setting up a disaster recovery offsite
> server to receive transaction logs from my SQL 2000 Enterprise server.
> Has anyone here used the log shipping features with SQL Enterprise,
> specifically through firewalls?
> 
> I have enough documentation on how to set it up, but I would like the
> skinny on what "really" happens when we try it, (not Bill Gates'
> comments) and any good ideas we might need to apply.
> 
> Rod Hurley
> Network Administrator
> Tenaska Marketing Ventures
> ph:  402-758-6187
> cell: 402-981-9561
> fx:   402-758-6275
> rhurley at tmvgas.com
> 
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug
>