Error: Database cannot be opened. It is in the middle of a restore when configure Mirroring on sql servers

Question

hi, i found many instructions how to configure mirroring between 2 SQL Servers 2016.
I recovered a backup on Mirror server with NoRecovery option. DB is in Restoring state.
I confgured Principal & Mirroring servers.
But when i click Start Mirroring button i receive a message:
Database cannot be opened. It is in the middle of a restore.
What is it? what did i do wrong?

Answer 1

Hi @Alibek Ismailov ,

Did you restore the latest transaction log backup？
Please refer to this: https://www.c-sharpcorner.com/article/error-927-database-cannot-be-opened/

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

It sounds like you are on the target server, instead of the source server. When creating mirroring you want to start from the source server.