...
Code Block | ||
---|---|---|
| ||
--get the name of your mirror endpoints select name from sys.database_mirroring_endpoints -- stop and start them ALTER ENDPOINT Endpoint_Mirroring STATE=STOPPED; GO ALTER ENDPOINT Endpoint_Mirroring STATE=STARTED; GO |
...
Code Block | ||
---|---|---|
| ||
--get the name of your mirror endpoints select name from sys.database_mirroring_endpoints -- stop and start them ALTER ENDPOINT Endpoint_Mirroring STATE=STOPPED; GO ALTER ENDPOINT Endpoint_Mirroring STATE=STARTED; GO |