Recovery Mode in SQL Server 2008

Vijay
Vijay used Ask the Experts™
on
What is the impact if i change Database (which is part of Transactional Replication) recovery model from SIMPLE to FULL in sql server 2008. the size of the DB is 800 GB
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
you should be fine...
however, you need to set Trans log backup for this DB


more Recovery Models (SQL Server)
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server


Backup Under the Full Recovery Model
https://technet.microsoft.com/en-us/library/ms190217(v=sql.105).aspx
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
If the database is part of a transactional replication then it can't be in SIMPLE recovery mode. It requires to be in FULL recovery mode.
Commented:
just FYI:
"What recovery model is required on a replicated database?

Replication functions properly using any of the recovery models: simple, bulk-logged, or full. Merge replication tracks change by storing information in metadata tables. Transactional replication tracks changes by marking the transaction log, but this marking process is not affected by the recovery model."

Frequently Asked Questions for Replication Administrators
https://docs.microsoft.com/en-us/sql/relational-databases/replication/administration/frequently-asked-questions-for-replication-administrators

Author

Commented:
Thank you very much Eugene.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial