Avatar of Vijay
Vijay
 asked on

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
DatabasesMicrosoft SQL ServerSQL

Avatar of undefined
Last Comment
Vijay

8/22/2022 - Mon
EugeneZ

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ão

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.
ASKER CERTIFIED SOLUTION
EugeneZ

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Vijay

ASKER
Thank you very much Eugene.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck