0

I have a database which is stuck in Synchronized mode and another database in Initializing / In Recovery mode. Both of them have been removed from their availability groups and I cannot even delete them. Both of them are in secondary server and I cant even do a failover. Any help is much appreciated.

UPDATE

When I try to delete the database in this state: Initializing / In Recovery, it says Lock request time out period exceeded.

When i try to delete the database in this state: Synchronized, it says certain operations cannot be performed while database is in a mirroring session., even though I have removed it from its availability group.

Improve this question
1
  • 1
    Have you restarted the SQL services on that secondary node ? Commented Aug 17, 2020 at 13:00

1 Answer 1

Reset to default
0

Use the query SHUTDOWN WITH NOWAIT on the server, then try restarting the services for the server.

Refer link for more information: https://blog.sqlauthority.com/2018/02/09/sql-server-change-pending-state-sql-server-configuration-manager/#:~:text=WORKAROUND%2FSOLUTION,and%20able%20to%20run%20queries.

Improve this answer
2
  • While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review Commented Aug 18, 2020 at 13:11
  • i have mentioned the solution found in the link here...the link contains the incident with the solution Commented Aug 18, 2020 at 14:00

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.