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?

    Thanks,
    adam1992, Nov 7, 2006
    #2

  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
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Nov 8, 2006
    #2

  3. MohammedU New Member

    http://msdn2.microsoft.com/en-us/library/ms190016.aspx


    Mohammed U.
    MohammedU, Dec 8, 2006
    #2

  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
    sree_hari, Jan 7, 2007
    #2

Share This Page