SQL Server Performance

Transaction Log Shipping Secondary DB Server

Discussion in 'SQL Server 2005 Log Shipping' started by LokeshG, Feb 26, 2009.

  1. LokeshG New Member

    Hi This is Lokesh, I am having query on Transaction Log Shipping Secondary DB Server.My Query is "can we do operations on Transaction Log Shipping Secondary DB Server", i mean, if i update the data in secondary db server will it go for toss as the data is not matching with original primary db server. please respond me on this ASAP.Thanks in advance.
  2. arunyadav Member

    Lokesh,
    You shouldn't update any data on secondary server because that will break the log shipping. In other words, the secondary database is not operational; it can stay in either read-only mode or no-recovery mode.
  3. LokeshG New Member

    Thanks arun, as i am also under the same impression but before i would like to confirm. Thanks for your reply.

Share This Page