Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Transaction Replication

Author  Topic 

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-03-11 : 00:38:03
I have a transactional replication set up in my environment and it's running fine. Now I wanted to add a new article (Table) to the publication with out generating a new snapshot because the snapshot generates hugh file (Database size is 100GB)

--
Ragu Thangavel
Junier Sql Server DBA

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-11 : 15:28:59
Can try Running sp_addArticle at the publisher then run sp_refreshsubscriptions also at the publisher.
Go to Top of Page
   

- Advertisement -