Hello there, Could someone help on suggest what would be the best option I have 60 GB Databse I am setting first time replication. 1. Copy /restore the production on subscriber ? What are all manual steps do I need to take care this thing to work . 2. Go ahead with regular replciation setps.[ Any idea how long it will take] Your help would be really helpful.
If you are using SQL Server 2000, this article might help:http://dotnetjunkies.com/WebLog/dinakar/articles/144151.aspx *********************** Dinakar Nethi SQL Server MVP ***********************
Check the following... NoSync Initializations (and variations) on SQL Server 2005 http://www.replicationanswers.com/NoSyncOn2005.asp MohammedU. Moderator SQL-Server-Performance.com
check out the documents on sp_addpublication http://msdn2.microsoft.com/en-us/library/ms188738.aspx set @allow_initialize_from_backup=true
URGENT At last implemented the replication. I missed for to set one table not for replication =YES ( subscriber database) I am going to create temp table copy all records from orignal tbl to temp tble then drop orignal table . rename temp to orig all these activities on subscriber table . Does it affect any thing? on replication? Distributor remembers ID'd subscirer database tables? Any help would be really appreicate..
I can see that will slow down the replication and other than this it shouldn't affect at all. If its not a problem thne why not reinstate replication with relevant settings. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.