Restoring a published Database -- sql server replication

georgeg
1/26/2006 6:17:05 AM

I have a 100GB published database. This database uses a transactional
replication. I have full, dif and transaction logs backups of the published
database. Whaat do I need to do to restore this databse without doing a new
snapshot? There are no backup of distribution or subscriber databses. Do I
need to do these backups?
--
George Gopie

Hilary Cotter
1/26/2006 12:49:21 PM

Use the keep_replication switch and follow the instructions at the bottom of
the sp_repldone section in bol. You may also need to issue a sp_replrestart.

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

sql server replication : Restoring a published Database