December 1, 2008 at 12:58 am
hi,
I would like to setup log shipping in a clustered sql server 2005. Configuring log shipping is same for clustered and non-clustered sql server 2005 or there any differences and special steps to consider?
Thanks
December 1, 2008 at 1:18 am
There is one difference that I remember. The definition of the network namefor the location to copy the backup files on the secondary server should be added as a resource in the cluster. If you won’t define it as a resource in case of failover the log shipping will not work.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 2, 2008 at 3:30 am
Adi is correct. define the location where the log backups will be held as a share and define that share as a resource in cluster administrator.
---------------------------------------------------------------------
December 2, 2008 at 7:57 am
Also be sure that the share is in the logshipping group in the cluster and that it has a dependency on the disks of the group so that it will failover with the group in the event of a problem.
Are you logshipping as due to DR or data safety concerns?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply