question

AlibekIsmailov-8900 avatar image
0 Votes"
AlibekIsmailov-8900 asked SeeyaXi-msft answered

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

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?

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
1 Vote"
SeeyaXi-msft answered

Hi @AlibekIsmailov-8900,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.