Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

Code Block
languagesql
--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