Home › SQL Server › SQL Server Mirroring

SQL Server Database Mirroring - Establishing a Database Mirroring Session


Establishing a Mirroring Session (Using a system name)

-- Mirror Server: ServerMir
-- Database Name: AdventureWorks

-- To run on Principal
ALTER DATABASE AdventureWorks
    SET PARTNER = 'TCP://ServerMir:5022'

Establishing a Mirroring Session (Using Fully Qualified Domain Name)

-- Mirror Server: ServerMir.Syntaxhelp.com
-- Database Name: AdventureWorks

-- To run on Principal
ALTER DATABASE AdventureWorks
    SET PARTNER = 'tcp://ServerMir.Syntaxhelp.com:7024'

Establishing a Mirroring Session (Using IPv4)

-- Mirror Server: 192.168.1.101
-- Database Name: AdventureWorks

-- To run on Principal
ALTER DATABASE AdventureWorks
    SET PARTNER = 'tcp://192.168.1.101:7024'

Establishing a Mirroring Session (Using IPv6)

-- Mirror Server: [2001:4898:23:1002:20f:1fff:feff:b3a3]
-- Database Name: AdventureWorks

-- To run on Principal
ALTER DATABASE AdventureWorks
    SET PARTNER = 'tcp://[2001:4898:23:1002:20f:1fff:feff:b3a3]:7024'

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.