Post reply

For replicated database recovery model must be full?

  • July 18, 2014 at 9:34 am

    #310128

    Hi all,

    We are creating replication for various databases. Some of them have Full recovery model, some Bulk-logged, an some even Simple.

    Should we change all of them to full?

    Thanks

  • July 18, 2014 at 9:54 am

    #1730682

    replication is at object level and it is not dependent on the recovery model of the database so it can be simple, full, bulk logged.

  • July 18, 2014 at 9:54 am

    #1730681

    Replication has no dependency on recovery models.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 18, 2014 at 11:27 am

    #1730712

    Thanks all.

    Just another question. I initialize replication with backup/restore. After restoring to subscriber, should I change subscription database to Simple recovery?

  • July 18, 2014 at 11:31 am

    #1730714

    If your publication database was already in simple, then the restored database should be in simple as well (upon completion of the restore).

    You can change the subscription database to simple independent of the setting of the publisher database.

    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 5 posts - 1 through 4 (of 4 total)

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