Wednesday, 1 August 2012

Set Up SQL Server Mirroring T-SQL Script

The first thing you need to do when setting up Database Mirroring is perform a full backup followed by a transaction log backup on the principal server.  You then must restore these to the mirror server using the WITH NORECOVERY option of the RESTORE command.  
at

3 comments:

  1. Caryn Cowles20 June 2018 at 11:09

    I have been looking for these codes. Thanks for sharing. Check out this site https://customwriting.com for impressive custom writing services.

    ReplyDelete
  2. coder1 September 2018 at 05:01

    Thanks great and very short article.
    I was facing issue while doing failover.
    [error msg:-The database mirroring service cannot be forced...]
    I would suggest to keep safety ON to avoid such error.
    Please refer below code.


    /*Set partner, set asynchronous mode, and setup job on principal server*/

    ALTER DATABASE DatabaseName SET PARTNER = N'TCP://MirrorServer:PortNumber'
    ALTER DATABASE DatabaseName SET SAFETY ON --use ON instead of OFF.
    EXEC sys.sp_dbmmonitoraddmonitoring -- default is 1 minute

    ReplyDelete
  3. Lawrence Todd Maxwell7 September 2018 at 07:00

    I had a great time reading this kind of valuable post. Please keep sharing and enlightening your readers' minds. Visit my Lawrence Todd Maxwell pinterest page when you have some spare time.

    ReplyDelete

Subscribe to: Post Comments (Atom)