Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcm
Starting Member
6 Posts |
 Posted - 2008-07-22 : 10:37:45
|
| hellowhat exactly is replication and what does it accomplish?tx |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-07-22 : 10:39:40
|
| i'm interested... where exactly did you hear the term and not understand it's purpose? classroom? interview?Em |
 |
|
|
mcm
Starting Member
6 Posts |
Posted - 2008-07-22 : 10:50:53
|
| read about it |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 10:52:00
|
quote:
Originally posted by mcm
read about it
Are you looking for suggestion or giving one? |
|
|
|
mcm
Starting Member
6 Posts |
Posted - 2008-07-22 : 11:07:02
|
| trying to find out what exactly is replication in regards to sql server 2005 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 11:14:39
|
quote:
Originally posted by mcm
trying to find out what exactly is replication in regards to sql server 2005
Replication is a warm-standby solution . It allows you to replicates same copy of tables into other server or other instances.You should check books online about Replication which comes with SQL Server CD. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-07-23 : 01:27:04
|
Replication is to put copies of the same data at different locations throughout the enterprise. And synchronizing between databases to maintain the consistency.Reasons:Moving data closer to the userReducing the locking conflicts when multiple sites wish to work with same dataAllowing site autonomy so that each location can set up its own rules and procedures for working with its copy of dataRemoving the impact of read-intensive operations such as report generation and ad hoc query processing from the OLTP databaseRead BooksOnline for types of replication and all...quote:
Originally posted by mcm
hellowhat exactly is replication and what does it accomplish?tx
|
|
|
|
|
|
|
replication