How to solve Error 927 'can not open database' while configuring DB mirroring

0 votes

6 answers

25057 views

sql-server sql-server-2016 mirroring

                          Steps I followed:

1. Create DB on primary.
2. Took full backup and log backup.
3. Restored full and log on secondary in NORECOVERY mode
   (now tb shows restoring satus on secondary I guess this is because NORECOVERY mode).
4. Tried configuring mirror from primary.

I was able to configure it successfully with windows 2012 and SQL server 2012 using SSMS 17.6 but it's giving above error with Win2k16 and SQl server 2016

Asked by TheBeginner (167 rep)

Apr 11, 2018, 10:18 AM
Last activity: May 11, 2023, 08:05 AM

How to solve Error 927 'can not open database' while configuring DB mirroring

Related Questions