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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2009-11-17 : 16:53:27
|
| While setting up transactional replication until setup is completed does the process lock the tables so users will not be able to use them. As far as I know we can setup transactional replication when users are still using the database or is it true that users should not be accessing the database while setting up replication. Can anyone please share their thoughts.Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-17 : 17:00:22
|
| it never locks the tables actually until snapshot is run |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Transactional replication