2006-06-16 16:50:30 · 4 answers · asked by Muhammad 1 in Computers & Internet ➔ Software
Many database engines have a feature know as "replication" built into them. This gives the ability to maintain one or more additional databases which are identical to the "master" database. When someone, say, adds a row to a table on the master, that same add is done on the slaves.
It's a good feature to have going when the disk containing your master database suddenly dies.
2006-06-16 16:55:30 · answer #1 · answered by Dave R 6 · 0⤊ 0⤋
As the name suggests, it's a mechanism for "replicating" or making a copy of a database on another server, and keeping the replicant in sync. There are several different reasons that people might want to do this including having a failover backup, feeding a datawarehouse or datamart, having a development server, or providing a distributed database. So there are accordingly different types of replication and different strategies required. For example, if you have a distributed database, there might be 3 seperate servers, each of which could receive an insert/update or delete. The other 2 servers will need to be able to synchronize. That's obviously a lot more complicated than if you just need a master -> slave copy.
2006-06-16 16:59:21 · answer #2 · answered by Gizmo L 4 · 0⤊ 0⤋
SQL Server replication is commonly described by using the publisher/subscriber metaphor. A database server that makes data available for replication (source server) is referred to as the publisher; a collection of one or more database objects that are enabled for replication is called a publication. SQL Server supports replicating tables, views, stored procedures, and user-defined functions.
One or more servers that get data and/or transactions from the publisher are called subscribers. Replication is managed by the system database, which by default is called distribution. A distribution database—which can reside on the publisher, subscriber, or on a separate server—is created when you configure replication.
The server that hosts the distribution database is referred to as the distribution server or distributor.
With Regards,
Kumar.
http://www.indianbabycare.com
http://www.tamilmasala.net
2006-06-16 16:54:12 · answer #3 · answered by IT-guru 5 · 0⤊ 0⤋
database replicas are the snap shot of databases. uasing this replication u can synchronize the databases. this process is known as replication.
2006-06-16 16:55:38 · answer #4 · answered by vasanth k 1 · 0⤊ 0⤋