subscriber alternate snapshot location and Web sync - 2005 express

Hot Topic

How To Execute an Oracle 10g Stored Proc thru ODBC using VS 2005, for Reporting Services
Cannot connect to SQL Server
Convert numbers to Month Name
ODBC --Call Failed exception in application?
Add a column to published table without replicating to subscriber
File Enumerator does not show after install of SP1
Can MS Sharepoint Services work with Reporting Services 2000??
SQL Server Management Studio Express CTP will not start
SQL 2000 and 2005 on the same cluster
Is assembly code replaceable?

SQL Server

Can This Be Accomplished in My Time Dimension in my AS2005 Cube?
logging DDL Stmts
Hidden vs. Internal Parameters -- Got to be a better way...
How to restore SQL 2005 DB to SQL 2000
Debugging pure T-SQ stored procedures
Could not find file 'C:\WINDOWS\system32\dbo.mdb
Please help- hairloss imminent (ProcessingAbortedException)
Snapshotting AS Cube
Complex query involving multiple tables
Running a package in C#

subscriber alternate snapshot location and Web sync - 2005 express

Hi,

If the snapshot location on a subscriber is changed to alternate location (like a local path), rather than the default "Download from Web Server", does that have any effect I have tried changing it, but the subscriber still appears to get the snapshot from the web server - does something have to be re-initialized after changing the subscription properties

Thanks

Answer this question

subscriber alternate snapshot location and Web sync - 2005 express

  • Chris Peeters

    Could you please describe in more detail what you are changing and where you are doing it

  • Alberto Pardo

    Hi

    Is there an answer on this


    We too would like to distribute the initial snapshot via CD.

    Thanks

    Bruce

  • Anu Viswan

    I ran through the scenario described in this thread and I see what needs to change.  On the subscriber you changed the snapshot location from "default location" to "alternate folder" in the snapshot properties (section 4) of the subscription.  If you scroll down further in the subscription properties to the "Web Synchronization" properties (section 7), you'll see that web sync is still enabled and this is why the merge was still pulling down the snapshot via web sync.  You need to change the "Use Web Synchronization" property to false in order to fully disable web sync for this subscription.  At this point, you should be able to apply the snapshot from the alternate snapshot folder that you specified.

    Hope this helps,
    Tom

    This posting is provided "AS IS" with no warranties, and confers no rights.

  • Robby Economides

    Sure - I am using SQL Server Management Studio Express CTP on a SQL 2005 Express instance. The instance is subscribed to a publication on a SQL 2005 server. I am changing the subscription properties on the subscriber using SQL Studio Express - the specific property I am changing is Property 4 (Snapshot). I change the snapshot location from Default to Alternate Folder, then change snapshot folder to local directory. I then hit OK, and then attempt to sync, but the subscriber still attempts to download from the web server.

    Let me know if you need more clarification.

    Thanks,

    Darrell Young

  • Thierry Tuo

    Is there any way to keep Web Sync on while using an alternate snapshot location as described above. Using WebSync allows us to take our publisher out of our DMZ and put it safely behind the firewall, but our snapshots can get pretty big so we usually ship them via CD to our subscribers who have unreliable dial-up connections. Also, I really don't want my users to be altering subscription properties when they have to apply a snapshot.

    Thanks,

    Zachmo
  • subscriber alternate snapshot location and Web sync - 2005 express
Answer this question