Change recovery model while the database is in replication

Question

We have a production database that is in full recovery mode.

This database is being replicated to another server. (transaction replication)

We have maintenance jobs run on Friday nights which include index rebuilding.

Transaction log backup files are huge after this maintenance job.

So I am thinking of changing the recovery model to simple before the maintenance job starts and change it back to full after the maintenance job.

Will this method impact the replication?

I know replication can work with any recovery model but not sure whether switching recovery models full to simple and then simple to full will have any impact on replication?

Any help/guidance will be much appreciated. Thanks.

TheGameiswar · Accepted Answer · 2017-05-21T08:50:43.913

2

I know replication can work with any recovery model but not sure whether switching recovery models full to simple and then simple to full will have any impact on replication?

Replication is not dependant on recovery model.Log reader agent scans the log and inserts them as commands in distributor database .log space can be reused only at this point of time after the insert is done then only log will get truncated(space can be reused).

So even if you change recovery model to full or simple,those settings won't affect replication and are not replicated

edited May 21 '17 at 08:50

answered May 15 '17 at 09:48

TheGameiswar

27,855
8
56
94

Also consider the impacts on the Backup plan – Hybris95 May 15 '17 at 10:23
@Hybris95 when a backup is running,log will be not truncated – TheGameiswar May 16 '17 at 03:36
1

I mean, switching from Full to Simple model may lead to the impossibility of restoring the transactions afterwards. A new full backup will be required to preserve the RPO. – Hybris95 May 16 '17 at 09:09

Change recovery model while the database is in replication

1 Answers1