Database Reference
In-Depth Information
F
Isolate the network connection between NIC2 of Principal instance and NIC2 of Mirror
instance.
Now, we are ready to implement the database mirroring endpoint configuration as a dedicated
mirroring session.
How to do it...
The endpoint configuration setup is possible using the Configure Database Mirroring
Security from SQL Server Management studio. For this recipe, we will create endpoints to
configure dedicated DBM sessions using
TSQL
methods, and also show you how it looks
when you configure with the wizards. The
CREATE
ENDPOINT
command is used to create the
mirroring endpoints. The syntax that applies to database mirroring is as follows:
CREATE ENDPOINT endPointName [ AUTHORIZATION login ]
STATE = { STARTED | STOPPED | DISABLED }
AS TCP (LISTENER_PORT = listenerPort )
FOR DATABASE_MIRRORING (
[ AUTHENTICATION = {WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ]|
CERTIFICATE certificate_name
} ][ [ , ] ENCRYPTION = { DISABLED |SUPPORTED | REQUIRED }
[ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ]
][,] ROLE = { WITNESS | PARTNER | ALL })
To create the endpoints using the Wizard, you will need to complete the following steps:
1. Expand the database pane and select the desired database to be chosen for
database mirroring.
2. Right-click on the database and select either the Mirror or the properties option.
3. If the properties option is selected, then click on Mirroring on the left-hand side of
the database properties screen.
4. On the right-hand screen from the status column we can see the value This database
has not been configured for mirroring.
5. Click on the Configure Security button to open up the configuration. This is where we
begin to setup the Endpoint configuration and data encryption option for database
mirroring pairs.
6. On the PRINCIPAL instance, execute the following from the query editor:
CREATE ENDPOINT Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=5022,LISTENER_IP=(161.19.70.02))
FOR DATABASE_MIRRORING (ROLE=PARTNER)
Search WWH ::
Custom Search