Answer / appaiah

Replication configuration prerequisites
If you are configuring replication on one or more servers, verify that the following prerequisites and conditions are met before you begin the configuration process:

Installation of a second dual-port Ethernet adapter (Feature Code 3448) is complete on any legacy 3958 DD1 servers being used for data replication.
Cable connections to the customer's replication network have been made. See Revising the cabling to support replication for additional information.
TCP ports 6520, 6530, 6540, 6550 are open in the customer's firewall. Each ProtecTIER® server being used for replication must allow TCP access through these ports.
You have the following information about the servers in the customer's replication network:
Replication Port 1 IP address
Replication Port 1 netmask
Replication Port 1 hostname (for example: jaguar_source_1)
Replication Port 2 IP address
Replication Port 2 netmask
Replication Port 2 hostname (for example: jaguar_source_2)
Note: Host names are case sensitive. Be aware of the use of upper- and lowercase characters when gathering the information and when entering it into the system.
The replication ports (ETH3 and ETH4), are on different subnets than each other. In addition, ETH3 and ETH4 must be on a different subnet than the external LAN port (ETH0). Having the replication ports and the external LAN port on the same subnet may cause replication errors.
Parent topic: Configuring replication

What is a deadlock and what is a live lock?

0 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

Explain about SQLOS?

0 Answers  

---

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

How to provide login information for a new odbc dsn?

0 Answers  

---

How to Update from select query in sql server?

0 Answers  

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

Can two tables have the same primary key?

0 Answers  

---

Explain few examples of RDBMS?

0 Answers   Wipro,

---