SQL Server Performance Forum – Threads Archive
role reverse in log shipping with Standard EditionHi! Is there a way to perform reverse roles in log shipping built on SQL Server Standard Edtion? Also, is it possible to put old production server again into production once the standby server is recovered without need to transfer full backup? Thank you! Gregory Entin
SQL Server 2000 Enterprise Edition must be installed on all servers used in log shipping.
If not perform your own log shipping from thishttp://www.sql-server-performance.com/sql_server_log_shipping.asp&e=7415 link. Also refer to books online for Role Changes – How to set up and perform a log shipping role change (Transact-SQL) for more information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.