Microsoft KB Archive/308872

= FIX: Unable to Overwrite Read-Only Dynamic Snapshot Pre_snapshot_script =

Article ID: 308872

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q308872



BUG #: 354079 (SHILOH_BUGS)



SYMPTOMS
In SQL Server 2000, for merge publications with dynamic filters, you can create dynamic snapshot jobs for improved performance. However, if the snapshot job has either the @pre_snapshot_command or @post_snapshot_command parameter set, and you execute the dynamic snapshot job more than once, the job might fail and the following error message occurs

Could not copy script file '\\shiloh2\repldata\unc\scripts\script1.sql' to the snapshot generation folder.

where the Script1.sql file in question is either the pre_snapshot_command or post_snapshot_command file. The path to the script file varies depending on your specific environment.



CAUSE
When you run the dynamic snapshot job for the first time, SQL Server generates the post- or pre-snapshot command files as read-only files. When the dynamic snapshot job is run again, it fails with the error message shown in the &quot;Symptoms&quot; section because it cannot replace the read-only file created in the first run of the job.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000.

This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

Keywords: kbbug kbfix KB308872

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.