Logshipping From a Cluster to a Cluster

Currently have 2 clusters for sql server 2000 enterprise
edition with one being my primary database server and
another at a DR site.
Is there any limitation which would prevent me from
logshipping my primary cluster to the secondary cluster?
Any violation of a best practice that you might see.
The clusters are configured as an active/passive cluster.
Any special tips or concerns/recommendations?I have never done that , but I think you should probably make sure that the
network share for the backups is a clustered network share, so it will be
available during failover...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jack Snow" <mrbrew5510@.hotmail.com> wrote in message
news:OABNb.57764$G04.12571479@.news4.srv.hcvlny.cv.net...
> Currently have 2 clusters for sql server 2000 enterprise
> edition with one being my primary database server and
> another at a DR site.
> Is there any limitation which would prevent me from
> logshipping my primary cluster to the secondary cluster?
> Any violation of a best practice that you might see.
> The clusters are configured as an active/passive cluster.
> Any special tips or concerns/recommendations?
>|||jack,
a couple of comments :-
if you are running statements like SELECT INTO or BCP into
on your primary server - these will not be log shipped as
they are 'non-logged' or 'minimally logged' operations.
Also, think how you would change your application to point
at the standby server if you did ever need to fail over ?
Normal log-shipping practice would be to rename your SQL
Server on the standby to be the same as the offline
primary server - this would be more complicated on a
cluster - you would probably have to repoint all your
application connections to the existing name of the
standby SQL Server. Would this mean changes on your
middle-tier, or changes on each SQL user's client network
utility ?
Hope this helps.
>--Original Message--
>Currently have 2 clusters for sql server 2000 enterprise
>edition with one being my primary database server and
>another at a DR site.
>Is there any limitation which would prevent me from
>logshipping my primary cluster to the secondary cluster?
>Any violation of a best practice that you might see.
> The clusters are configured as an active/passive cluster.
>Any special tips or concerns/recommendations?
>
>.
>