Transnational Replication

  • Hi,

    I am using Transnational replication of Microsoft SQL Server 2008. I always face one problem when distributor database fails eventually. It requires re-initializing subscriptions when I restore distributor database. This takes time once my database size is very big. Can someone tell me how to back up and restore subscription and distributor database?

    Best regards;

  • what do you mean by distribution database fails? what's the reason behind it?

  • jason123 (11/9/2013)


    Hi,

    I am using Transnational replication of Microsoft SQL Server 2008. I always face one problem when distributor database fails eventually. It requires re-initializing subscriptions when I restore distributor database. This takes time once my database size is very big. Can someone tell me how to back up and restore subscription and distributor database?

    Best regards;

    Something is lost here. Do you mean the "published user database" or the system database called [Distribution].

    What do you mean by database fails? Do your subscribers experience an error?

    I think you mean you are restoring the published database and reinitialising the subscribers.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply