SQL Server Performance Forum – Threads Archive

Snapshot Folder location for Clustered SQL

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

maybe you can download this white paper and have a detailed understanding:
http://www.microsoft.com/downloads/…a9-60c1-490e-bd8f-c43c707720ac&DisplayLang=en

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

see if this link can help you…
http://msdn2.microsoft.com/en-us/library/ms188918(SQL.90).aspx

THat may very as the NP is using SQL 2000 version.
http://www.sql-server-performance.com/q&a24.asp a bit of information. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>