Post reply

Backups Done on a Production Database that is Now Going to be Replicated

  • October 13, 2009 at 10:07 am

    #216264

    Currently on SQL Server 2005 SP3 CU4 on 64 bit server.

    Tomorrow morning I will be setting up Transactional Replication for our production database. Currently for our production database a full backup occurs at midnight and every half hour I do a transactional log. Because I am going to replicate this production database do I need to change how I do backups on this production database? Will the transactional replication affect the backups on the production database?

  • October 13, 2009 at 8:19 pm

    #1065476

    Implementing replication shouldn't have any affect on your backup / restore strategy. Depending on how often the logreader agent runs, transaction may remain in the transaction log longer than they currently do but once the logreader agent has processed them, they can removed from the transaction log. This should happen automatically assuming that your current log backups periodical truncate the transaction log.

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

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