• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 59
  • Last Modified:

Recovery Mode in SQL Server 2008

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
0
Vijay
Asked:
Vijay
  • 2
1 Solution
 
Eugene ZCommented:
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
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
 
Eugene ZCommented:
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
1
 
VijayAuthor Commented:
Thank you very much Eugene.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now