Groups | Blog | Home
all groups > sql server replication > november 2005 >

sql server replication : Transactional Replication


Patrick
11/14/2005 3:09:40 PM
Hi Freinds,
I am trying to establish a transactional replication between 2 servers in
west and east coast.
Database is almost 80GB in size and contains more than 2000 tables.

At the first try , I failed to push snapshot to subscriber, I am getting
timeout errors, also by current tunnel that we have , It is very slow to
proceed.

I was wondering if there is another way to invoke repliation.
Like copying the backup file to subscriber and then from that point start
the replication, so I don't need to push all data again !

What will be my othere alternatives ?

Thank in advance,
Patrick

Tejas Parikh
11/14/2005 3:41:03 PM
Yes, you can do that. On the subscriber side, restore the backup. Then start
creating the publication but make sure you click 'No, The subscriber already
has the schema and data' when it asks you to initialize during the creation
of your subscription... You'll have to create the sp's used by transactional
replication also manually if you do this.
http://support.microsoft.com/kb/299903/EN-US/
it tells you how to create those sp's you'll need.
Hope this helps.

AddThis Social Bookmark Button