SQL Server Performance Forum – Threads Archive

Intial Replication -URGENT REq

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
***********************

---

Sorry we are going to use SQL 2005

---

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.

---

]]>