January 20, 2020 at 10:13 am
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)
January 20, 2020 at 10:22 am
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.
March 15, 2021 at 6:50 am
This was removed by the editor as SPAM
September 1, 2021 at 6:15 am
This was removed by the editor as SPAM
September 2, 2021 at 10:22 am
This was removed by the editor as SPAM
September 2, 2021 at 10:22 am
This was removed by the editor as SPAM
September 9, 2021 at 7:08 am
This was removed by the editor as SPAM
September 9, 2021 at 7:08 am
This was removed by the editor as SPAM
September 25, 2021 at 12:09 pm
This was removed by the editor as SPAM
September 27, 2021 at 8:19 am
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
February 21, 2022 at 7:57 am
This was removed by the editor as SPAM
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply