Recommended Publication DB Recovery Model

Last Post 16 Feb 2007 06:36 AM by JHunter. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
16 Feb 2007 06:30 AM
For SQL 2000 transactional replications, what is the recommended recovery model for the publication databases?

The publication databases are static data that gets backed up once per week. They are currently on full.

Thank you.
JHunter
New Member
New Member

--
16 Feb 2007 06:36 AM
If your data is static, then the recovery model isn't important as only changes will be logged.

Jamie
PaulMcKibben
New Member
New Member

--
16 Feb 2007 12:14 PM
Ok. My assumption was that with a transactional replication, I needed the recovery model to be full.

You are saying that the recovery model could be simple, and the replication will work fine, correct?


Acceptable Use Policy
---