sql server new users: Question regarding Transactional Replication -- sql server new users

Question regarding Transactional Replication

sqlnewbie
2/21/2006 7:23:27 PM

sql server new users:

Hi,

Just a quick question, if I want to implement Transactional Replication on a
database, does that database have to be in Full back up mode? If I have the
database in Simple backup mode will it replicate all transactions?

Thanks in Advance,

Re: Question regarding Transactional Replication

Mike Hodgson
2/22/2006 12:00:00 AM

Transactional replication works fine when the published tables are in a
database in SIMPLE recovery mode.

--
*mike hodgson*
http://sqlnerd.blogspot.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.