SQL Server Performance

restore database on replication

Discussion in 'SQL Server 2005 Replication' started by reethu, Apr 30, 2007.

  1. reethu New Member

    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
  2. satya Moderator

    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.

Share This Page