CODEWITHSUNDEEP
sqlsql-serverhigh-availabilitydatabase-mirroring
user3881234
user3881234

Reputation: 1

SQL Server HA-DR for mirroring , How to recover mirroring when...?

what is the fastest way to recover databases mirroring after the primary server shut down and the mode of the primary db is in recovery padding or in mode not synchronize?

Upvotes: 0

Views: 104

Answers (2)

emad
emad

Reputation: 73

I suggest that deactivate mirroring and then active your mirroring again:

by following query you can deactivate mirroring:

Alter Database YourDatabase Set Partner = off

Upvotes: 1

muhmud
muhmud

Reputation: 4604

If the primary is In Recovery, you cannot simply restart mirroring, i.e. you'll have to use backups to recreate it and then re-establish mirroring.

If it's Suspended, as is usually the case if you lose the primary, start using the mirror, and then bring the primary up again, then you only need to resume:

alter database [your_db] set partner resume

Upvotes: 2

Related Questions