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.
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.
Thanks arun, as i am also under the same impression but before i would like to confirm. Thanks for your reply.