Saturday, November 19, 2011

What is LOCAL Area Network ?













Any device whose resources can be share and controlled

Which device can be connected :

1. Any device,which has a interface
2. Has a software to control its operation

What is interface ?
Serial, Parallel, Ethernet,ATM, Packet Switch , etc

Telnet, http,SNMP, SMPT etc are application to access / control the resources.
Network 













LAN Topologies :

1. Bus : 10base2,10base5
2.Star : 10base-T,100bassTx,
3. Ring : FDDI, Token Ring,





























Ethernet

1. Ethernet Overview
2. Definition : Ethernet is defined as protocol using Carrier Sense Multiple Access with Collision Detection (CSMA/CD). It supports data transmission rate of 10 Mb/s using Coaxial, Twisted pair or Fiber optic. Other versions of Ethernet is Fast Ethernet and Gigabit Ethernet , supporting 100 Mb/s and 1000Mb/s respectively. It comes in the 1st and 2nd Layer of OSI model.
3. History : It was first developed by Xerox in 1970 to connect Computers with Printers. Later in 1979 , DEC, Intel and Xerox joined hand for its standardization and formally released on 1982.

The 1st IEEE standard was released on 1983 as IEEE 802.3 . Later other improved version were
developed for different media .

.IEEE 802.3a is for Thin Ethernet or 10Base2 for cheaper coaxial cable.
.IEEE 802.3I or 10Base-T for twisted pair cable.
.IEEE 802.3d or 10Base –FL Fiber Optic cable.
.IEEE 802.3x or 1000Base-X for full duplex connection
.IEEE 802.3ab or 1000Base_T is the latest standard for 1Gb/s speed on UTP Cat5 cables.


Ethernet Standards:
. 10Base2/IEEE 802.3a: This supports data rate up to 10 Mb/s through thin coaxial cable for maximum distance of 185 m.
. 10Base5 : This is for Thick cable and supports up to 500 m .
. 10Base-T/IEEE802.3I :This supports data rate up to 10 Mb/s through UTP cable for maximum distance of 100 m.
•IEEE802.3u :This version is called Fast Ethernet and supports data rate up to 100 Mb/s through :
a) 100Base-TX on two pair UTP Cat 5 cable for maximum distance of 100 m,. b) 100Base-T4 on four pair UTP Cat 3 cable for maximum distance of 100 m,. c) 100Base-FX on one pair Multi-mode Fiber Optic Cable up to 2000m .
. 1000Base-X or IEEE 802.3z : This version is called Gigabit Ethernet and support three types of media as Single mode, Multi mode Fiber Optic cable and STP cable
. 1000Base-T or IEEE 802.3ad is for 1Gb/s over 4 pairs of UTP cables up to 100 m.

Ethernet Media Access Control

There are two type of topology in Ethernet one Bus and Star structure. The 10Base2 and 10Base5 are traditional Bus structure which operates only in half duplex transmission. 10Base –T and 100Base-tx are Star topology supports full as well as half duplex transmission.
1. Half Duplex
2. Full Duplex
3. VLAN
4. Multilink Trunking
5. Layer 3 Switch





Half Duplex Ethernet : TX or RX at a time with 10 MBPS data speed





Full Duplex Ethernet : TX and RX simultaneously with 10 MBPS effective speed 20MBPS





Full Duplex Fast Ethernet : TX and RX simultaneously with 100 MBPS effective speed 200MBPS





Multilink Trunking : Both the links works simultaneously with 200 MBPS effective speed 400MBPS

VLANs are technology which groups ports into VLANs into broadcast domains .This is a way to logically divide the switch. The packets, IP multicast, unicast frames can be forwarded to the ports of same VLAN.

1.5 Multilink Trunking
This technology allows to group many ports into one link together to increase the bandwidth and throughput between the devices.

Servers

Layer 3 Switch
LAN segment 2 

LAN segment 4


Layer 3 Switch
LAN segment 2 
 
LAN segment 4


1.5 Multilink Trunking
This technology allows to group many ports into one link together to increase the bandwidth and throughput between the devices.

Servers



Ethernet Physical Layer Specifications.
Brief summary of various physical layer specification defined in Ethernet is as follows.
2.1 10 Base-5
2.2 10 Base-2
2.3 10 Base-T
2.4 10 Base-FL
2.5 100 Base TX
2.6 100 Base FX
2.7 1000 Base X


2.1 10 Base-5
Transmission Rate:
10 Mb/s (full-duplex not supported)

Cable Type:
A single "thick" (10mm) coaxial cable with 50 ± 2 ohms impedance,
Supports bend radius of 2.54 cm (10 inches),
Eg. Belden part numbers 9880 (PVC) & 89880 (plenum rated)

Maximum Segment Length: 500 meters (1640 feet)
Maximum Transceiver Cable(AUI) Length: 50 meters (164 feet)
Maximum Number of Transceivers per Segment: 100
Connector Technology: N-type coaxial connectors, barrel connectors, & terminators
Signal Encoding: Manchester encoding


2.2 10Base2
10Base2 supports a 10 Mb/s transmission rate over "thin" (5mm) coaxial cable. Transmission Rate
10 Mb/s (full-duplex not supported)


Cable Type:
A single "thin" (5mm) coaxial cable with 50 ± 2 ohms impedance, G58A/U or RG58C/U, Supports bend radius of 5 cm (2 inches), Belden part numbers 9907 (PVC) & 89907 (plenum rated)
Maximum Segment Length: 185 meters (606.9 feet)
Minimum Spacing Between Stations: 0.5 meters
Maximum Number of Transceivers per Segment: 30
Connector Technology: BNC Tee coaxial connectors, barrel connectors, & terminators
Signal Encoding: Manchester encoding



2.3 10 Base-T
Transmission Rate:
10 Mb/s (20 Mb/s in optional full-duplex mode) Cable Type two pairs of Category 3 or better unshielded twisted pair (UTP) cabling,also known as voice grade or telephone twisted pair cabling,100-ohm impedance rating AMP, Lucent etc.
Maximum Segment Length:100 meters (328 feet)
Maximum Number of Transceivers per Segment: 2
Connector Technology: RJ-45 style modular jack ( 8-pins)
Signal Encoding: Manchester encoding



2.4 10Base-FL
10Base-FL ("fiber link") supports a 10 Mb/s transmission rate over two fiber optic cables. The 10Base-FL standard updates and expands the prior Fiber Optic Inter-Repeater Link (FOIRL) standard. 10Base-FL supports a maximum segment length of 2000 meters compared with 1000 meters supported by FOIRL.

10Base-FL may be used to connect two switch, two repeaters, or a computer and a repeater port. All 10Base¬FL segments are point-to-point with one transceiver on each end of the segment. The transceiver attaches to the two fiber optic cables through connectors that are commonly known as "ST". One fiber optic cable is used to transmit data, and the other is used to receive data.

The fiber optic cable typically used with 10Base-FL is multi-mode fiber (MMF) known as "62.5/125". The wavelength of light used with 10Base-FL is 850 nanometers. In addition to supporting longer segment lengths, fiber optic cables are immune to electrical hazards such as lightning strikes and ground currents that can occur when connecting separate buildings. Fiber is also immune to electrical noise that can be generated by motors or other electrical equipment.

Transmission Rate:
10 Mb/s (20 Mb/s in optional full-duplex modeCable Type two multi-mode fiber optic cables (MMF),
typically 62.5/125 fiber, (62.5 micron fiber core with 125 micron outer cladding) 850 nanometer light wavelength
Maximum Segment Length: 2000 meters (6561 feet)
Maximum Number of Transceivers per Segment: 2
Connector Technology: ST connector
Signal Encoding: Manchester encoding

2.5 100Base-TX
100Base-TX supports a 100 Mb/s transmission rate over two pairs twisted pair cabling. It uses one pair of wires for transmitting data, and the other pair for receiving data. The two pairs of wires are bundled into a single cable that may often include two additional pairs of wires. If present, the two additional pairs of wires must remain unused since 100Base-TX is not designed to tolerate the "cross talk" that can occur when the cable is shared with other signals. Each end of the cable is terminated with an 8 position RJ-45 connector, or "jack". It supports transmission over up to 100 meters of 100 ohm Category 5 unshielded twisted pair (UTP) cabling. 100Base-TX transmits data using the "4B/5B" signal encoding scheme .

The 100Base-TX standard supports the option of using 150 ohm shielded twisted pair (STP) cabling.

Transmission Rate:
100Mb/s (200 Mb/s in optional full-duplex mode) Cable Type two multi-mode optical fibers (MMF), typically 62.5/125 multi-mode fiber,1300 nanometer light wavelength
Maximum Segment Length: Half-Duplex: 412 meters (1351 feet)
Full-Duplex: 2000 meters (6561 feet)
Maximum Number of Transceivers per Segment: 2
Connector Technology:
duplex SC connector preferred, ST connector and FDDI MIC
connector also permitted
Signal Encoding: 4B/5B

2.6 100Base-FX
100Base-FX supports a 100 Mb/s transmission rate over two fiber optic cables. It allows maximum segment lengths of 412 meters for half-duplex links, and 2000 meters or more for full-duplex links. Even longer distances can be supported with the more expensive single mode fiber (SMF). 100Base-FX is essentially a "fiber" version of the 100Base-TX standard. The twisted pair cabling and connectors used in 100Base-TX components are replaced with fiber optic cabling and connectors in 100Base-FX components. Both standards use the same 4B/5B signal encoding scheme.
The fiber optic cable typically used with 100Base-FX is multi-mode fiber (MMF) known as "62.5/125". The wavelength of light used with 100Base-FX is 1300 nanometers.
The 100Base-FX standard allows several types of fiber optic connectors to be used. Duplex "SC" connectors are recommended, but "ST" and FDDI "MIC" connectors are also permitted.
Transmission Rate 100Mb/s (200 Mb/s in optional full-duplex mode) Cable Type two multi-mode optical fibers (MMF), typically 62.5/125 multi-mode fiber,1300 nanometer light wavelength
Maximum Segment Length Half-Duplex: 412 meters (1351 feet)
Full-Duplex: 2000 meters (6561 feet)
Maximum Number of Transceivers


2.7 1000Base-X
The identifier "1000Base-X" refers collectively to the 1000Base-LX, 1000Base-SX, and 1000Base-CX "Gigabit Ethernet" standards described in the following sections. Each of these standards are based on physical layer specifications adopted for Fibre Channel. In particular, 1000Base-X uses the same "8B/10B" coding scheme as Fibre Channel, and similar optical and electrical specifications.
With 8B/10B signaling, every 8-bits of user data are converted into a 10-bit symbol prior to transmission over the media. The overhead associated with the extra bits requires that a signal transmission rate of 1.25 gigabaud be used to transfer a net 1 Gb/s of user data.
The 1000Base-X standard defines a Gigabit Media Independent Interface (GMII) that attaches the Media Access Control (MAC) and Physical Layer (PHY) functions of a Gigabit Ethernet device. GMII is analogous to the Attachment Unit Interface (AUI) in 10 Mb/s Ethernet, and the Media Independent Interface (MII) in 100 Mb/s Ethernet.

2.7.1 1000Base-LX
The "L" in 1000Base-LX stands for "long" as it uses long wavelength lasers to transmit data over fiber optic cable. The long wavelength lasers specified by the standard operate in the wavelength range of 1270 to 1355 nanometers. Both single mode and multi-mode optical fibers are supported. Long wavelength lasers are more expensive than short wavelength, but have the advantage of being able to drive longer distances.

Transmission Rate:
1000 Mb/s (2000 Mb/s in optional full-duplex mode) Cable Type two 62.5/125 or 50/125 multi-mode optical fibers (MMF), or two 10 micron single mode optical fibers (SMF), 1270 to 1355 nanometer light wavelength
Maximum Segment Length: Half-Duplex MMF & SMF: 316 meters (1036 ft)
Full-Duplex MMF: 550 meters (1804 ft)
Full-Duplex SMF: 5000 meters (16,404 ft)
Maximum Number of Transceivers per Segment: 2
Connector Technology: duplex SC connector
Signal Encoding: 8B/10B



3 Ethernet Switch
Ethernet Hub receives a packet in one port and repeats it to all the ports, this allows all the machines to share the medium and
communicate one at a time. In case of Switch the packets are forwarded to only the port in which machine is connected. Thus the
medium is shared by multiple systems at a time.

The functions of Ethernet switch has been improved drastically from 10 Mb/s half duplex to 1 Gb/s full duplex.

Many new features are added as VLAN, tunneling , filtering etc. The architecture of Switches have been changed store and forward to cut through , or a combination of both.

The functionality and the performance of the switch are compared by the following parameters.

1. Architecture : whether cut-through or store and forward.
2. Physical functionality : on the basis of number and type of ports, up gradability, type of uplink etc.
3. Logical functionality : on the basis of type and level of filtering, broadcast / multicast / runt packets.
4. VLASN support : No. of VLANs, Type of VLASN support Port wise, MAC, service etc.
5. Manageability : Levels of RMON and SNMP supported
6. Latency : Backplane speed and forwarded speed.
7. MAC address Table size : The application of the switch mostly depends upon the size of MAC table.

The Switches can be grouped into the following types according to the application :

1. Desktop switch : these are used for connecting Client directly. The size of MAC table is small.

2. Work group switch : these are used to connect hubs/ desktop switches to the backbone network. Usually their one or more uplink ports with MAC table size more than 500 entries. Other features as VLAN , filtering.

3. Backbone switch : these are used for connecting different LANs. The backbone switch should have high latency table, medial independent port, large MAC table size, hot swappability , redundant power supply.


Configuring the Baystack 350 10/100/1000 Switch.
Configuration task :
1.connect a console to a Terminal ( 9600 baud , no parity, 8 bits, 1 stopbits ) using the DB-9 pin RS232 straight cable.

2. From the Main menu ,Select IP Configuration/Setup..Enter the IN-Band IP address, Subnet Mask and default gateway.

3.From the Main menu , Select the SNMP Configuration .. There are 4 Traps , provide IP address of the SNMP Station one by one.

This is the minimum configuration required to access the switch from the SNMP station. To check try to telnet from the SNMP Station to the switch . If you get the login prompt then the basic configuration is OK.
For special configuration as VLAN, Trunking, etc,select Switch Configuration from the Main menu.


Configuring the Baystack 350 10/100/1000 Switch.
Configuration task :
1.connect a console to a Terminal ( 9600 baud , no parity, 8 bits, 1 stopbits ) using the DB-9 pin RS232 straight cable.
2. From the Main menu ,Select IP Configuration/Setup..Enter the IN-Band IP address, Subnet Mask and default gateway.
3.From the Main menu , Select the SNMP Configuration .. There are 4 Traps , provide IP address of the SNMP Station one by one.

This is the minimum configuration required to access the switch from the SNMP station. To check try to telnet from the SNMP Station to the switch . If you get the login prompt then the basic configuration is OK.
For special configuration as VLAN, Trunking, etc, select Switch Configuration from the Main menu. , Select Switch configuration

VLAN Configuration Examples
The Network diagram There are two User groups in VLAN 1 and VLAN2 , who access the application
Servers Server 1 and Server 2 respectively.

The Mail servers and the Router for WAN connection is accessed by all , and is member of VLAN3.
The two Back bone 350 switches are connected through multi link trunks.
The configuration includes .

1. Configuring Backbone switches SWB1 and SWB2.
\SWB1 :
ports 1,5,7,11are untagged member of VLAN1 with PVID of port 1 & 11 is= 1
ports 2,5,7,12 are untagged member of VLAN 2 with PVID of port 2 & 12 is =2
ports 1,2,5,7,11 & 12 are untagged member of VLAN 3 with PVID of port 5 & 7 is =3

SWB2:
ports 1,2,3,5,7,9,11 & 12 are untagged member of VLAN1 with PVID of port 3,5,7, & 9 is =1
ports 1,2,4,6,8,10,11&12 are untagged member of VLAN 2 with PVID of port 4,6,8 & 10 is=2
ports 1,2,3,4,5,6,7,8,9,10,11 & 12 are untagged member of VLAN 3 with PVID of port 1,2,11& 12 is =3

To configure SWB1
1. VLAN 1: select Switch configuration from Main menu, then VLANconfiguration.
2. From the VLAN configuration , select VLAN configuration.
Create a VLAN : [ 1 ]
Delete a VLAN :[ ]
VLAN Name : [ VLAN1]
port numbers :
1 2 3 4 5 6 7 8 9 10 11 12
U ---U -U ---U ¬

Create a VLAN : [ 2 ]
Delete a VLAN :[ ]
VLAN Name : [ VLAN2]
port numbers :
1 2 3 4 5 6 7 8 9 10 11 12
-U --U -U ----U

Create a VLAN : [ 3 ]
Delete a VLAN :[ ]
VLAN Name : [ VLAN3]
port numbers :
1 2 3 4 5 6 7 8 9 10 11 12
U U --U -U ---U U

To configure the PVID
From the VLAN configuration Menu , select VLAN port configuration
port : [ 5]
Filter Tagged Frames [ no]
Filter Untagged Frames [no]
Filter unregistered Frames [no]
port name : [trunk1]
PVID : [ 3]

Similarly configure all the ports as per the PVID for both the switch.

2. Configuration of Desktop switches ( 303) SW1 and SW2.
In 303/304 switch don’t support the multiple VLAN on one port.To connect both the VLANs to the backbone switch one extra ports are configured.Select switch SW1
1. From the main menu , select -2 ( System configuration)
2. Select 8 ( port VLA configuration )
3. Select VLAN1 , mark port 1 to 6
4. Select VLAN 2 , mark port 7 to 12

Similarly for SW2 configure port 1 to 6 for VLAN1 and port 7 to 12 for VLAN 2.

Disable Spanning Tree protocol for all the Switches

3. To configure Multi Link Trunk :
1 From the switch configuration menu, select Multi link Trunk configuration Menu.

Trunk Trunk Members STP learning Trunk Mode Trunk Status
1 [5][7] disabled basic enabled

Monday, October 10, 2011

WORLD WIDE WEB

ANSIAerospace Standards


 





What is the World Wide Web?
The World Wide Web (WWW) is a global interactive, dynamic, cross platform, graphical hypertext information system that runs on the Internet.

What is WWW ?
WWW is a system for creating and browsing distributed HyperTexts. WWW hypertexts link machines around the globe. They contain links to
files, newsgroups, ftp, telnet, gopher, archie, and WAIS .



















HYPERTEXT


What is “The Web”
  • Hypermedia means that you can retrieve text, sounds (music or spoken language), movies, or pictures.
  • You are only limited by your computer’s hardware and software.








Enter the World Wide Web
  • With a Web client, users can access the internet
  • Seek scientific information
  • Surf for the heck of it
  • Buy and sell products and information



What is a Web Page?
A Web Page is a single document written in HTML (Hyper Text Mark-up Language) that includes the text of the document, its structure, any links to other documents and graphic images and other media.


Jargon for the Internaut ....
  • HTTP ,
    HyperText Transfer Protocol is the stateless protocol used for data transfer within WWW.
  • HTML ,
    WWW documents are authored using the HyperText Markup Language ,a subset of SGML.






















Jargon for the Internaut ...

















World Wide Web Client
A client /browser is a program that enables you to access the World Wide Web .
  • Formatted text with fonts
  • Inline / External images
  • Sound
  • Video
  • Java
  • VRML and more ...

What is a Web Browser?
A Web Browser is special software such as Netscape, Mosaic or  Internet Explorer. These browsers allow a user to view Web pages delivered from a client server (Web Site) situated at a particular URL on the World Wide Web.

Clients galore ...
  • Character Based Lynx
  • Graphical User Interface Netscape Navigator, Cello, PowerBrowser, Cyberjack, Microsoft Internet Explorer, Mozilla Firefox, NCSA Mosaic , Spyglass Mosaic , HotJava,WebSurfer, and many more ...

 

Internet Explorer



Mozilla Firefox


Search Engines on the WWW
  • Tools on the WWW used to search and find web sites related to a particular topic
  • provide for searching using keywords and boolean operators
  • Popular ones are Google, Alta Vista, Infoseek, HotBot,Web Crawler, Lycos and Yahoo
  • Over 600 + at present

World Wide Web Server
A Web Server is the software on an Internet site that enables Web Browsers to access HyperMedia Documents sitting
on the Web site .
Homepage is a HyperText document a server will serve as default .

 
How a server works !?!
  • The Client request received at the port where server daemon is waiting
  • The request is interpreted following the Rule Set defined at the server
  • The server sends a response containing a status code and the text of the document, if available
















Servers Galore !
NCSA , CERN , Netsite , Basis Web Server, WebForce, Netscape Commerce, Netscape Enterprise and scores of others
...


Serve what ? How ?
  • Web Authoring
  • Documents are created in HTML
  • Multimedia Elements in respective tools
  • Common Gateway Interface (CGI)
  • HTML
  • HTML versions 1.0, 2.0, 3.2, 4.0
  • Tags
  • Presentation Style
  • Perceived audiences
  • Bandwidth




728X90


 

Hang In There !
  • It can frustrating at times. 
  • Have patience and remember that you are on a great frontier.

 

Official E-guide from BradyGames

The official strategy guide from BradyGames

Wednesday, September 28, 2011

Assemble PC

How to assemble your own PC (Personal Computer)

If you are thinking of building your own PC (Personal Computer), or need practical information about PC hardware or software, you have come to the right place. With easy to follow step by step guide combined with many images even a beginner can build, configure and setup their own PC.

To Know more about Click Hear.



Tuesday, September 13, 2011

Replication Concept

Replication Concept

Ø      Replication

ü      Allows you to make duplicate copies of your data

ü      Move the copies to different locations, and synchronize the data automatically so that all the copies have the same data values.

ü      Replication can be implemented between databases on the same server or different servers connected by LANs, WANs, or the Internet.

Ø      Components of Replication
ü      Publisher , distributor and subscriber
ü      Publication
ü      Push and Pull subscriptions
ü      Replication agents

Ø      Publisher

ü      Is a server that makes data available for replication to other servers.
ü      Identifies which data is to be replicated
ü      Detects any changed data and maintains information about all publications at that site.

Ø      Subscriber

ü      Are servers that store replicated data and receive updates.
ü      Subscribers can make updates to data.
ü      A Subscriber can, in turn, become a Publisher to other Subscribers

Ø      Distributor

ü      The Distributor server
o       Contains the distribution database
o       Stores metadata, history data, and (for transactional publications) transactions.



Ø      Publication

ü      Is a collection of articles, and an article is a grouping of data to be replicated.
ü      An article can be an entire table, only certain columns (using a vertical filter), only certain rows (using a horizontal filter), or even a stored procedure (in some types of replication).
ü      A publication can have multiple articles.

Ø      Push Subscription

ü      Publisher propagates the changes to a Subscriber without a request from the Subscriber to do so.
ü      Typically, used in applications that are required to send changes to Subscribers whenever and as soon as they occur.
ü      Best for publications that require near real-time movement of data .
ü      Used in cases when the higher processor overhead at the Publisher does not affect performance.
ü      Changes can also be pushed to Subscribers on a scheduled basis.

Ø      Pull Subscription

ü      With a pull subscription, the Subscriber asks for periodic updates of all changes at the Publisher.
ü      Pull subscriptions are best for publications having a large number of Subscribers eg.Subscribers using the Internet.
ü      Pull subscriptions allow the user to determine when the data changes are synchronized.
ü      A single publication can support a mixture of push and pull subscriptions.

Ø      Agents
ü      Snapshot agent
ü      Log reader agent
ü      Distribution agent
ü      Merge agent

Ø      Snap shot Agent
ü      Prepares schema and initial data files of published tables and stored procedures.
ü      Stores the snapshot on the Distributor and records information about the synchronization status in the distribution database.
ü      Each publication has its own Snapshot Agent that runs on the Distributor and connects to the Publisher.
ü      The Snapshot Agent is run typically under SQL Server Agent and can be administered directly using SQL Server Enterprise Manager.

Ø      Log reader Agent
ü      The Log Reader Agent moves transactions marked for replication from the transaction log on the Publisher to the distribution database.
ü      Each database published using transactional replication has its own Log Reader Agent that runs on the Distributor and connects to the Publisher.

Ø      Distribution Agent
ü      The Distributor receives all changes to published data, stores the changes in its distribution database, and transmits them to Subscribers.
ü      The Distributor may or may not be the same computer as the Publisher.
ü      Push subscriptions to either snapshot or transactional publications have Distribution Agents that run on the Distributor.
ü      Pull subscriptions to either snapshot or transactional publications have Distribution Agents that run on the Subscriber instead of the Distributor.
ü      Merge publications do not have a Distribution Agent.

Ø      Merge Agent
ü      It is the agent in merge replication, that applies initial snapshot jobs held in publication database tables to Subscribers.
ü      It also merges incremental data changes that have occurred since the initial snapshot was created.
ü      Push subscriptions to merge publications have Merge Agents that run on the Publisher.
ü      Pull subscriptions to merge publications have Merge Agents that run on the Subscriber.

Ø      Types of replication
ü      Snapshot
ü      Transactional
ü      Merge

Ø      Snapshot replication
ü      Simplest type of replication
ü      A picture, or snapshot, of the published data in the database at a moment in time.
ü      All this data is sent to the Subscriber instead of sending just the changes in data.
ü      Hence subscribers are updated by a total refresh of the data set.
ü      Guarantees transactional consistency between the Publisher and Subscriber.


ü      Snapshot replication is carried out by the Snapshot Agent and the Distribution Agent.
ü      The Snapshot Agent prepares snapshot files containing schema and data of published tables and stores the files in the snapshot folder on the Distributor, and records synchronization jobs in the distribution database on the Distributor.
ü      The Distribution Agent moves the snapshot jobs held in the distribution database tables to the destination tables at the Subscribers.
ü      The distribution database is used only by replication and does not contain any user tables.


Ø      Transactional replication
ü      Used to replicate two distinct types of objects: tables and stored procedures.
ü      Uses the transaction log to capture changes that were made to data in an article.
ü      The modifications made to the data like Insert, Delete etc are monitored and stores these changes in the distribution database.
ü      Changes are then sent to Subscribers and applied in the same order.
 

Ø      The Snapshot Agent
ü      Prepares snapshot files containing schema and data of published tables,
ü      stores the files in the snapshot folder on the Distributor
ü      records synchronization jobs in the distribution database on the Distributor.

Ø      The Log Reader Agent
ü      monitors the transaction log of each database set up for replication
ü      copies the transactions marked for replication from the transaction log into the distribution database.


Ø      The Distribution Agent
ü      moves the transactions and initial snapshot jobs held in the distribution database tables to Subscribers.

Ø      Merge replication

ü      Merge replication tracks changes in a source database and synchronizes the values between the Publisher and Subscribers, all of whom may update data.

ü      Data changes at the destination database are propagated to the source database.

 

Replication is carried out by the Snapshot Agent and
Merge Agent.

Ø      The Snapshot Agent
ü      prepares snapshot files containing schema and data of published tables,
ü      stores the files in the snapshot folder on the Distributor,
ü      records synchronization jobs in the publication database.

Ø      The Merge Agent
ü      applies the initial snapshot jobs held in the publication database tables to the Subscriber.
ü      merges incremental data changes that occurred at the Publisher after the initial snapshot was created
ü      reconciles conflicts according to rules you configure or using a custom resolver you create.

Steps in replication:

1. Configuring replication

(a) Done by replication wizards, available from the SQL Server Enterprise Manager Tools menu. You can use these wizards to enable, modify, and disable servers as Distributors, Publishers, and Subscribers.

Tools >>Replication >> Configure Publishing, Subscribers and distribution

Or

(b) Using the GUI of Enterprise manager
Click on the server name
Select replicate data >>configure replication



2. Create Publication Wizard to create a publication

(a) Using the Enterprise Manager Tools menu
Tools >>Replication >>Create or manage publication
Or

(b) Use the GUI of Enterprise manager Select the create or manage publication icon



3. Use the push or pull subscription

Ø      Push Subscription Wizard

Push Subscription Wizard to create one or more push  subscriptions to each publication on a Publisher.

ü      Using the wizard, you can specify:
o       One or more servers or server groups to receive the publication as Subscribers.
o       The destination database, which must exist on all Subscribers.
o       Subscription properties

ü      Tasks to be performed before the subscription can be created:
o       Create the publication
o       Create a destination database at each subscribing server
o       If selecting more than one server or server group, use the same destination database name at each Subscriber.

Ø      How to start the Push Subscription Wizard (Enterprise Manager)
To start the Push Subscription Wizard

ü      Expand a server group; then expand the Publisher.
ü      On the Tools menu, point to Replication, and then click Push Subscription to Others.
ü      Expand the database containing the publication in which to create a subscription.
ü      Click the publication; then click Push New Subscription.
ü      Complete the steps in the wizard.
Ø      Pull subscription wizard

Using the Pull Subscription Wizard, you can specify:

ü      The publication to which you want to subscribe.
ü      The name of the destination database to be used for the subscription.
ü      Subscriber properties, such as the synchronization schedule with the Publisher, the visibility of the subscription to other Subscribers, whether the subscription can update data, and what priority each Subscriber has when there is a conflict of changes.


Ø      How to start the Pull Subscription Wizard (Enterprise Manager)

To start the Pull Subscription Wizard
ü      Expand a server group; then expand the Subscriber.  
ü      On the Tools menu, point to Replication, and then click Pull Subscription To....
ü      Click Pull New Subscription.
ü      Complete the steps in the wizard.