Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
We have Windows Server 2016 and on it SQL server 2016 standard edition is installed. Another windows server 2016 machine has mirroring of SQL server configured.
Lets call Primary SQL server as A and Mirrored SQL server as B.
ON A we will delete DB and restore from some existing backup.
My question is do I need to recreate mirroring configuration between A & B?
You cannot just delete or drop db when mirroring is configured. You have to remove mirroring alter database dbname set partner off.
Then drop database on primary.
Then restore from the desired backup.
Then reset up mirroring - take full and log backup and restore it to server B with NO_RECOVERY.
Remember : Mirroring is deprecated technology. So you should either use basic availability group or if you are on Enterprise edition then go with AlwaysON.
