SQL Server Performance Forum – Threads Archive
standby server in log shipping
I want to do log shipping for a production database. My standby server (secondary server )is SQL server cluster which is already hosting other production databases. can standby server be used as production server for applications which dont use databaseinvolved in log shipping ? if yes, what is the effect of log shipping on other databases on the stand by server
Why you want to the secondary server which is a part of cluster node?
You might risk the log shipping when there is any automated failover with cluster environment, IMHO do not mix the servers for consistency servers. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
We have something similar in place here: a SQL server with some databases in production and one database which is a warm standby. It is not completely the same as your setup, since we don’t use the builtin logshipping but a custom made job which does the same.
This way, the impact on the other databases on the standby server is close to nothing (just the performance impact of restoring the logs). Early morning, when I wake up,
I look like Kiss but without the makeup –Robbie Williams, Strong
But why do you need so when you have high-end availability option with Clustering then using log shipping doesn’t make any sense to me. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>