Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: How to bring up warm stabdby server?

    Hello, everyone:

    I am making disaster recovery plan and considering technical details. My question is that if I configure log shipping and primary server is failed. I have to bring up secondery server online. As warm standby server, the secondary server is Read-only. How to disable read-only?

    Thanks

    ZYT

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by yitongzhang
    Hello, everyone:

    I am making disaster recovery plan and considering technical details. My question is that if I configure log shipping and primary server is failed. I have to bring up secondery server online. As warm standby server, the secondary server is Read-only. How to disable read-only?

    Thanks

    ZYT
    SQL 2000 or SQL 2005?

    Do a google for "log shipping sql recovery" or something close to that. There's a document on the MS website that shows how to do it with step-by-step details. It's been so long, I have long since ditched it, but I used to keep a printed copy in my DR handbook.

    Regards,

    Hugh
    Have you hugged your backup today?

  3. #3
    Join Date
    Mar 2003
    Posts
    223
    Hi Hugh:

    I am running SQL 2000.

    Thanks for the advices. I read a ton of papers. Almost all papers are from BOL to recommend last restore transaction log backup from primary server with recovery. I am conderning if it is for sure the secondary server can resume general model from read-only after restoration. Does any one have real experience? If the secondary server runs online with Real-only, that is a big trouble.

    ZYT



    Quote Originally Posted by hmscott
    SQL 2000 or SQL 2005?

    Do a google for "log shipping sql recovery" or something close to that. There's a document on the MS website that shows how to do it with step-by-step details. It's been so long, I have long since ditched it, but I used to keep a printed copy in my DR handbook.

    Regards,

    Hugh

  4. #4
    Join Date
    Mar 2003
    Posts
    223
    Hello, everyone:

    I would like share this point with you. My testing was executed by "How to: Set Up, Maintain, and Bring Online a Warm Standby Server (Transact-SQL)" in BOL step by step. After restore from last transaction log backup from primary server WITH RECOVERY. Like,

    RESTORE LOG northwind1
    FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL$Subscription_srv\Log\Northwind_tlog_2 00407111530.TRN'
    WITH RECOVERY

    Refresh secondary database, it become general model from Read-Only.

    Thanks

    ZYT

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •