SQL Server Performance

Log shipping SQL 2005

Discussion in 'SQL Server 2005 Log Shipping' started by adam1992, Nov 7, 2006.

  1. adam1992 New Member

    SQL 2005
    I have a DB set up for log shipping, A ships to B
    the backup DB 'B' stays on a status of "restoring"
    what is the method for cutting over to the log shipped DB 'B' and bringing it online for use?

  2. satya Moderator

    Only in case of any issues on Primary server you would need to get the server B to get online.
    Have a look at Log shipping topic under SQL Server 2005 books online.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. MohammedU New Member


    Mohammed U.
  4. sree_hari New Member

    You can change the log shipping properties to set the remote server as "Stand-by" mode if you want set the remote server as Read-Only mode so you can read the data in the secondary server

    Hari Devarakonda

Share This Page