sql server replication: Hello there

I have two servers: Publisher, Subscriber
Between them there is transactional replication
On both servers the recovery model is simple.

If the publisher goes down and the database has been corrupted. and I need
to recovery the last 3 hours of working. Can I use replication log to revive
the last 3 hours instead of transfer to full recovery model which will
reduce performance?

Yes, but the record may not be complete. It will only be complete for the
articles you are replicating. So if you are replicating every table it will
be complete except for the system objects.

For this to work you will need to 1) have a backup done before the 3 hour
window.

2) have turned off your distribution clean up agent or have your transaction
retention something greater than 3 hours.

3) be able to access your distribution database.

--
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]