FIX: Unable to Overwrite Read-Only Dynamic Snapshot Pre_snapshot_script (308872)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
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 "Symptoms" section because it cannot replace the read-only file created in the first run of the job.
RESOLUTIONTo 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
STATUSMicrosoft 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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbbug kbfix KB308872 |
|---|
|