SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

It Depends

Add to Technorati Favorites Add to Google
Browse by Tag : Replication,SQL Server (RSS)

Init from Backup Published on SSC

By Andy Warren in It Depends | 02-11-2008 7:13 AM | Categories: Filed under: ,
Rating: (not yet rated) Rate this |  Discuss | 459 Reads | 88 Reads in Last 30 Days |no comments

This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it can be a very handy technique for all that. Strangely it's not supported via the UI, you have to add the subscription manually and then everything works normally from there. Heres the link: Init From Backup.


Replicate Stored Procedure Execution Published on SSC

By Andy Warren in It Depends | 11-05-2007 1:51 PM | Categories: Filed under: , ,
Rating: (not yet rated) Rate this |  Discuss | 618 Reads | 106 Reads in Last 30 Days |no comments

Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the publisher are applied one row at a time on the subscriber using the system generated procs created on the subscriber. I actually tend to agree with the concept, opting for a vanilla implementation whenever possible! Needing to update or delete a large number of rows is one place where vanilla plus a dab of butterscotch in the form of replicating stored procedure execution can make a big difference in overall time/resource usage.

Here's the link: http://www.sqlservercentral.com/articles/Replication/61332/