Post reply

differential back up to initialize my transactional subscription

  • August 28, 2009 at 2:12 pm

    #210135

    can i use differential back up to initialize my transactional subscription?

    my full back is too large to setup the replication for every maintenance so if i can use differential back up on top of my existing backup on subscriber.

    any help appreciated.

    http://msdn.microsoft.com/en-us/library/ms147834.aspx

  • August 28, 2009 at 3:46 pm

    #1046422

    Just to be clear i am thinking below steps

    remove subscription

    take differential back up on publisher

    create subscription on the basis of differential back up above

    restore differentail backup of publisher on subscriber(this step i am not sure how it will match the LSN)

  • August 30, 2009 at 10:55 am

    #1046629

    Any taker pls?

  • August 30, 2009 at 9:30 pm

    #1046705

    A differential backup only contains the pages that have changed since the last full backup. This is why it is so much smaller than your full backup.

    You will not be able to a differential backup because it will not have all of your database in it (unless every single page was updated, of course).

  • August 31, 2009 at 10:32 am

    #1046972

    thnx , the only question here , is there any way i can restore publisher differential backup on top of my already existing subscriber database?

  • August 31, 2009 at 11:18 am

    #1046997

    After you restore the Full back to your subscriber, you can then restore the diff on the subscriber.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 6 posts - 1 through 5 (of 5 total)

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