Replication: how to change snapshot folder?

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  July 17, 2014 at 8:10 am

  #310006

  While configuring replication in SSMS Wizard, I made a grave mistake by not setting snapshot folder to \\server\path form.

  Now I need to:

  1. Find what the current path for snapshot. I could not find it in Distributor Properties.

  2. Change it to new one.

  Thanks

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  July 17, 2014 at 8:49 am

  #1730292

  Try this article

  http://www.mssqltips.com/sqlservertip/2785/changing-sql-servers-default-snapshot-folder-for-replication/

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events