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 2008 Forums
 Replication (2008)
 trans replication

Author  Topic 

AgaK
Yak Posting Veteran

86 Posts

Posted - 2011-02-09 : 11:52:07
Hi,

I need to replicate certain tables of a 50GB db but the definitions of all the tables need to be in the replicated db. What would be the best method to do it? Replicate everything and then remove subscriptions for the tables that we don’t want to see the data?
Thanks a lot!
AK

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-09 : 12:23:40
50GB isn't that much and can be snapshot pretty quickly. Just replicate the tables you need.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -