SQL Server Performance

Bringing the secondary database online

Discussion in 'SQL Server 2005 Database Mirroring' started by xiebo2010cx, Feb 5, 2007.

  1. xiebo2010cx Member

    I had a database mirroring configured for a long time, the secondary server is in hot standby(restoring) mode, I decided to stop the mirroring and bring the secondary server online today,

    What I did is:
    1. From primary server, remove mirroring, then do a transaction log backup
    2. Copy the tlog to secondary server, restore the tlog with recovery option

    So far, the database is OK, I just wondering if I missed something?

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  2. satya Moderator

    Can you see the database on secondary server ok?
    If so then yesit is the procedure and make sure the logins are synchd anyway.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. xiebo2010cx Member

    After restoring the TLog file with recovery option from primary node, the secondly node is OK, I also checked the contents of both nodes, they are identical.

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  4. satya Moderator

    Should be ok then, as an additional check you might refer to SQL Server error log.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page