Change recovery model while the database is in replication
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.
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 ,at this point of time only,the 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
What is the structural behaviour of SSIS in it's Pre-execute phase of package execution ? Why the heavy packages hangs in Pre-Execute phase?
Reports no longer run after change from SQL 2008r2 to SQL 2014r2
How to update multiple tables from excel file in SQL server
how to rename database in local disck to attach again in sql server
SQL Server login timeout expired when running sqlcmd
SQL Server : executing table-valued functions strangely
Supporting RESTful UPSERTS in Microsoft SQL
insert large amount of AD data into SQL server using PowerShell
Do READ ONLY file groups reduce locking
importing SQL Server .bacpac file
Sql Server pivot command based on text giving null cells
Insert data in another server via linked query
Counting special characters in SQL
How to solve below scenario in ssis?
“Back Up” not appearing in SQL Server Management Studio 2016 or 17
Visual Studio 2015 Schema compare not displaying changes