Mirroring is failing in MS SQL Server 2016

  • I m trying to set Mirroring in MS SQL Server 2016.

    Everything looks fine still mirroring is failing with error: Database 'DatabaseName' cannot be open. It is in the middle of a restore. (Microsoft SQL Server, Error:927 mybkexperience)

    • This topic was modified 1 year, 9 months ago by  Jake229.
  • The "mirror" copy is not accessible to clients, if you want to use the mirror for reporting and reading from etc, you will need to create a database snapshot of the database and point your clients to that.

     

    What is your purpose for mirroring?  Secondary reporting?  HA DR?

     

    Also why was mirroring chosen?  The technology has been on the depreciated list since the release of 2012 as MS advise to avoid it and use Availability Groups instead.

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This seems to be a bug in SSMS, after issueing full and log backups, and restoring them in NORECOVERY mode at the mirror instance side, try to execute the following commands:

    In Mirror instance:

    ALTER DATABASE <Database Name>
    SET PARTNER =
    'TCP://<Your Principal Server>.<Domain>:<Mirroring Port>'
    GO

    Lite Blue

    • This reply was modified 3 weeks, 3 days ago by  Robert897.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply