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?
Best Answer
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.