How to Remove database mirroring in SQL Server
Steps to focus for removing mirroring from SQL Server.
1. Disable the mirroring option by setting the partner off.
Command:
Use Master
Go
Alter database database_name set partner off
Go
/* Above command should be executed in Primary server where Database is Principal server */
2. Connect to Mirror database host server and run the below command
Command:
Use Master
Go
Restore database database_name with recovery
Go
Now Mirrorring is disabled and both the Principal and Mirror database are up and online.
Hope the above information helps
Thanks
