replication question

[parsql]

Hi all,

is it possible to set up the transaction replication without having down time because i tried creating but when it runs initial snapshot it takes long time due to around 4 Millions records on the single table!!

is it possible create without having down time for users to work on db!!!

advise!!!

 

[mrdenny]

Nope. SQL Replication locks the objects in the database while it makes the snapshot.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com