SQL Server Performance Forum – Threads Archive

restore database on replication

please may i know i am trying to restore database from network path but this database has replication (publication)
so how can i perform this restore without distrub that publication.
after restore publication should get immediate access to the users, SRJ2005

Answered your question there:http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20964&whichpage=2
Look under BOoks online for " Backing Up and Restoring Replicated Databases" topic in this case and you can use KEEP_REPLICATION option. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>