Home › SQL Server › SQL Server Mirroring

SQL Server Database Mirroring - Altering mirroring configurations


Adding a Witness Server to a Database Mirroring Session

-- Database Name: AdventureWorks
ALTER DATABASE AdventureWorks 
  SET WITNESS = 'TCP://ServerWit:7022'

Removing the Witness Server from a Database Mirroring Session

-- DatabaseName: AdventureWorks
ALTER DATABASE AdventureWorks SET WITNESS OFF

Terminating Database Mirroring Session

-- Terminate Mirroring Session of AdventureWorks database
-- Command to be run on the Principal Server.
ALTER DATABASE AdventureWorks SET PARTNER OFF

To Pause a Database Mirroring Session

-- Suspending Mirroring Session on AdventureWorks database
-- Command to be run on the Principal Server.
ALTER DATABASE AdventureWorks SET PARTNER SUSPEND

Resuming Database Mirroring Session

-- Resuming Mirroring Session on AdventureWorks database
-- Command to be run on the Principal Server.
ALTER DATABASE AdventureWorks SET PARTNER RESUME

Changing Mirroring Session to Asynchronous Mode

-- Database Name: AdventureWorks
ALTER DATABASE AdventureWorks SET SAFETY OFF

Changing Mirroring Session to Synchronous

-- Database Name: AdventureWorks
ALTER DATABASE AdventureWorks SET SAFETY ON

Turning Transaction Safety ON

-- Database Name: AdventureWorks
ALTER DATABASE AdventureWorks SET PARTNER SAFETY FULL

Turning OFF Transaction Safety

-- Database Name: AdventureWorks
ALTER DATABASE AdventureWorks SET PARTNER SAFETY OFF

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.