tag:blogger.com,1999:blog-4510394351870137228.post8482456239894968245..comments2024-03-13T09:30:19.783-04:00Comments on Gnawgnus Realm: SQL 2008 Transactional Replication and initializing from a backup fileUnknownnoreply@blogger.comBlogger10125tag:blogger.com,1999:blog-4510394351870137228.post-2905526475736549642014-03-25T15:40:12.429-04:002014-03-25T15:40:12.429-04:00Its very useful.
For add an article after initiat...Its very useful.<br /><br />For add an article after initiating the replication from backup use this link <br /><br />Link : http://blogs.msdn.com/b/repltalk/archive/2011/03/15/how-to-add-an-article-to-an-existing-transactional-subscription-initialized-through-backup.aspx?Redirected=truesivahttps://www.blogger.com/profile/01274293301381965777noreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-36028627815414125162011-04-26T11:25:52.653-04:002011-04-26T11:25:52.653-04:00I'm also looking to add an article after initi...I'm also looking to add an article after initiating replication from backup, and it's not snapshotting, any help would be appreciated.Unknownhttps://www.blogger.com/profile/01060865057851718496noreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-33535033274739124332011-04-12T07:26:57.909-04:002011-04-12T07:26:57.909-04:00I haven't done that yet but as I understand it...I haven't done that yet but as I understand it you can do it with TSQL. This link is probably it: http://msdn.microsoft.com/en-us/library/ms146887.aspxGnawgnuhttps://www.blogger.com/profile/07664150859605394627noreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-68537043409422273852011-04-12T03:49:55.647-04:002011-04-12T03:49:55.647-04:00How do I add a new article to an existing replicat...How do I add a new article to an existing replication initializing from a backup file ?Davidnoreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-33893662450194704722010-12-01T07:31:30.417-05:002010-12-01T07:31:30.417-05:00Probably. Everything I've read on it implies ...Probably. Everything I've read on it implies that it'll work either way but I haven't tested my procedure with it.Gnawgnuhttps://www.blogger.com/profile/07664150859605394627noreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-18123337245015743812010-12-01T05:05:36.524-05:002010-12-01T05:05:36.524-05:00In step 8, is a pull subscription required? I'...In step 8, is a pull subscription required? I'm in an environment that requires a push subscription. Thanks.Quickdraw6906https://www.blogger.com/profile/10981455592486567721noreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-44800393270540952142010-08-11T07:27:52.767-04:002010-08-11T07:27:52.767-04:00Sure, just follow the wizards on both ends and ski...Sure, just follow the wizards on both ends and skip most of my steps above and it works out of the box. Your DB will slog down to near unresponsive for a while and it'll generate a stack of replication files on the snapshot folder structure which will transport over to the subscriber server. This method is only recommended for smaller databases or situations where you have a fast connection. In our case it would have been 14 hours of sync time instead of 1 hr for the backup copy method.<br />As for the second question, when you set up the publication you get to choose what tables and other types of data that you want replicated. You can tell it to just publish a single table if you want. Hope that helps.Gnawgnuhttps://www.blogger.com/profile/07664150859605394627noreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-28544006342340782552010-08-11T06:17:31.013-04:002010-08-11T06:17:31.013-04:00Couple of questions
01. Is it possible to initia...Couple of questions<br /><br /> 01. Is it possible to initialize the replication on the subscriber without actually restoring the backup?<br /><br />02. The initialization from backup assumes the entire database to be replicated. If we want to replicate only few individual tables, what additional steps we need to perform?<br /><br />Thanks,<br />NSRAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-72717741295670883822010-05-27T08:13:28.462-04:002010-05-27T08:13:28.462-04:00Great guide. Doing a backup/restore vs snapshots (...Great guide. Doing a backup/restore vs snapshots (as recommended by MS) made this a lot more friendly for our scenarios (reporting server away from production).Benhttps://www.blogger.com/profile/11501866860529565379noreply@blogger.comtag:blogger.com,1999:blog-4510394351870137228.post-82361743745189788262010-02-03T22:48:45.136-05:002010-02-03T22:48:45.136-05:00Thanks a lot.
It's very useful.Thanks a lot.<br />It's very useful.kaochiuanhttps://www.blogger.com/profile/14154782804647239879noreply@blogger.com