Home » sql server 2017 mirroring error 927

sql server 2017 mirroring error 927

sql server DBA 999

SQL Server Error : 927, Severity: 14. Database ‘%.*ls’ cannot be opened. It is

SQL Server Error : 927 Details

SQL Server Error: 927 Severity: 14 Event Logged or not: No Description: Database ‘%.*ls’ cannot be opened. It is in the middle of a restore. Severity 14 Description: Indicates security-related errors, such as permission denied.

Steps to recreate or create this error

  1. Create or select Database on primary for mirroring.
  2. Took full backup and log backup.
  3. Restored full and log on secondary in NORECOVERY mode
  4. Tried configuring mirror from primary.
  5. Then click “Start Mirroring”
  6. And here volla….  you  may will get the error: 927.
Actually this is not an error, this msg tell us that the database, for which you want to configure the mirror, is not fully restored
Read the rest