sql-server


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

Related Links

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

Categories

HOME
ibm-watson-cognitive
npm
winapi
angular-cli
nuxeo
azureservicebus
actionscript-2
x11
ctypes
automata
cs-cart
ssms-2016
thumbnails
nmake
explode
jquery-scrollify
opencart2.3
pptp
superscript
android-vpn-service
consumer
skygear
modelandview
fabric-digits
mapguide
large-data
service-locator
npm-publish
dql
soundjs
datalog
intersystems-ensemble
homekit
pytest-django
amazon-clouddrive
fqdn
recycle-bin
appstore-approval
jags
istorage
multi-agent
paas
date-range
libreadline
tomee
c#-interactive
tuxedo
radians
metalsmith
windows-nt
dbscan
magento-1.4
mirrorlink
built-in
castle-windsor-3
rx-groovy
coypu
gulp-livereload
callstack
cpan
symfony-2.6
grunt-contrib-concat
genetic-programming
java-collections-api
config-files
operations
.net-cf-3.5
database-permissions
awesomeprint
graph-coloring
pys60
jpf
v4l
mysql-error-1045
scraperwiki
handwriting
external-assemblies
visual-c++-2008-express
callgrind

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App