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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much Eugene.
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