August 22, 2006 at 8:20 am
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!!!
August 22, 2006 at 8:51 am
Yes, just back up the database and restore it on the subscriber. Then, when you create the subscription using sp_addsubscription, use the @sync_type = 'none' parameter to tell SQL Server that the subscriber already has the schema and initial data. This option is also available somewhere in the GUI.
John
August 27, 2006 at 8:05 pm
But records at the publisher might change after the backup is taken but before the db is restored and replication is set up .... or am I missing something here ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply