Post reply

Transactional Replication(Push) and initializing from a backup file

  • December 9, 2010 at 8:44 pm

    #229508

    Hello my friends,

    I have a rather larger DB that I would like to create replication for. Because the DB is such a beast the only way to get the replication up and running is to initialize via a backup. The environment is as follows

    Server A - Publisher

    Server B - Distributor

    Server C - Subscriber

    Now i've copied the backup file locally on Server C and ran the following code

    exec sp_addsubscription

    @publication = N'ReplicationAlpha',

    @subscriber = N'Server C',

    @destination_db = N'ReplicationAlpha',

    @sync_type = N'initialize with backup',

    @backupdevicetype = 'disk',

    @backupdevicename = 'C:\temp\ReplicationAlpha.bak',

    @subscription_type = N'push',

    @update_mode = N'read only'

    GO

    And i'm recieving the following message :unsure:

    Msg 21397, Level 16, State 1, Procedure sp_MSaddautonosyncsubscription, Line 279

    The transactions required for synchronizing the nosync subscription created from the specified backup are unavailable at the Distributor. Retry the operation again with a more up-to-date log, differential, or full database backup.

    Can anyone out in the interweb advise me on what is wrong/to do 🙂

    Cheers,

    Remember
    Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

  • December 12, 2010 at 4:16 pm

    #1261471

    Hey Guys,

    I thought I would give an update, my issue was that the backup wasn't the most update verison of the DB, the log file must of recorded an entry(I specifically told my collegues to not touch the DB). Now even thou i managed to get the Subscriber to initialise from the backup, it didnt work as i had planned.

    I was hoping to copy the backup to the Sub and have it initialised from there, rather than the backup be on the Pub, then copied to the Distributor and then initialised to the Sub.

    Does anyone know of a way to initialise a Sub from a backup which is local on the Sub??

    Many thanks 🙂

    Remember
    Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

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

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