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 |
|
chetan_dba
Starting Member
21 Posts |
 Posted - 2008-04-07 : 02:38:24
|
| Hi,I wanted to know What is the biggest hurdle that i can faced while implementing replication?Do let me know.Thanks in advance.-- Chetan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 09:12:22
|
| If the tables you are trying to replicate is huge,then creating snapshot takes whole amount of time and locks the table/databases so nobody can access. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 17:22:24
|
| You also have option to unlock tables while creating snapshot for first time. Check sp_addpublication in BOL. |
|
|
|
betesh
Starting Member
34 Posts |
Posted - 2008-06-17 : 06:18:38
|
| What is BOL? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-17 : 07:25:17
|
| Books Online, SQLs help file.The biggest issue you can face is that the syncronisation can time out and get stuck in a loop, but you need huge unweildy tables for that to happen in 2005. |
|
|
|
|
|
|
Biggest Hurdle while implementating Replication