Tuesday, March 20, 2012

Can I combine Log Shipping and Clustering?

SQL Server 2005 SP2

Can I combine Log Shipping and Clustering? That is, can I
ship logs from the primary node in my cluster to an offsite
warm standby SQL server box?

Any help appreciated.

TIA

aj"aj" <ronald@.mcdonalds.comwrote in message
news:13k3vep1gmodlec@.news.supernews.com...

Quote:

Originally Posted by

SQL Server 2005 SP2
>
Can I combine Log Shipping and Clustering? That is, can I
ship logs from the primary node in my cluster to an offsite
warm standby SQL server box?
>


Certainly. They're two completely unrelated features.

And it's fairly common to in fact do what you propose.

Quote:

Originally Posted by

Any help appreciated.
>
TIA
>
aj


--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

No comments:

Post a Comment