sql server replication: Whate recovery model for distribution database? -- sql server replication

Whate recovery model for distribution database?

hmscott
7/27/2007 11:56:00 AM

sql server replication:

What recovery model should I use for the distribution database? By default
it is simple, but something tells me that this is not optimal.

We are using SQL 2005 (SP1) with a Dynamic, horizontally partitioned Merge
Publication. The publisher and distributer are separated.

Thanks,

Re: Whate recovery model for distribution database?

Hilary Cotter
7/28/2007 12:00:00 AM

For merge simple is probably ok. For transactional I would recommend full,
merely to maintain the log as it's io characteristics tend to be write
intensive.

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]