SQL Server Performance

standby server in log shipping

Discussion in 'SQL Server Log Shipping' started by kramer3, Sep 27, 2006.

  1. kramer3 New Member

    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 database
    involved in log shipping ?

    if yes, what is the effect of log shipping on other databases on the stand by server
  2. satya Moderator

    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.
  3. catullus Member

    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
  4. satya Moderator

    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.

Share This Page