SQL Server Performance

role reverse in log shipping with Standard Edition

Discussion in 'SQL Server Log Shipping' started by Entin, Jan 26, 2004.

  1. Entin New Member


    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

  2. satya Moderator

    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.

Share This Page