SQL Server Performance

Snapshot Folder location for Clustered SQL

Discussion in 'SQL Server Clustering' started by np70, Jun 1, 2006.

  1. np70 New Member

    Hi,
    I have transactional replication setup on SQL 2000 cluster using updateable push subscribers. While setting up replication, we chose default location for snapshot folder that resides on non-clustered drive. Is there a way to change this location without disturbing current replication setup. I looked at the 'alternate snapshot location' solution, but it requires snapshot re-initialization. According to this article, if non-clustered device is used, replication may stop working in case of cluster failover. So, is there a chance that my replication will work with snapshot folder on non-clustered device? Is there anything else I can do to make sure it works?
    Thanks,
    np70
  2. smy New Member

  3. np70 New Member

    smy,
    Thanks for the link to White Paper. It has lots of good information explaining trans replication and troubleshooting. However, it also has same recommendation for alternate snapshot location (i.e. apecify it before you apply the snapshot to the target subscriber). In my case, I have already created subscribers and applied initial snapshot. If I have to follow this recommendation, I need to setup all subscribers again. I am trying to find out solution without disturbing current setup.
    np70
  4. smy New Member

  5. satya Moderator

Share This Page