Monday, March 19, 2012

Explore Snapshot Err After SP3a

Server 2000 on WIn XP Prof.
Since installing SP3a this morning I am getting a nasty dialog saying "The Specified File Was Not Found" when I use the Explore Snapshot button or the Explore the Latest Snapshot Folder menu item.
This happens both with merge and snapshot publications when the snapshot files are in fact present and sp_browsesnapshotfolder and sp_browsemergesnapshotfolder each return the correct path.
If the snapshot is not there then then the usual message that the snapshot has either not been created or has been cleared appears.
Despite the error message, the snapshots can still be applied so its really just an irritant and a worry that if something is wrong it may cause other undetected problems.
Has anyone got any idea how I can correct this please?
are you using dynamic filtering?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Bruce Thomas" <Bruce Thomas@.discussions.microsoft.com> wrote in message
news:28CCE323-2AFF-4D7F-86FE-9EE3E8AAE9DC@.microsoft.com...
> Server 2000 on WIn XP Prof.
> Since installing SP3a this morning I am getting a nasty dialog saying "The
Specified File Was Not Found" when I use the Explore Snapshot button or the
Explore the Latest Snapshot Folder menu item.
> This happens both with merge and snapshot publications when the snapshot
files are in fact present and sp_browsesnapshotfolder and
sp_browsemergesnapshotfolder each return the correct path.
> If the snapshot is not there then then the usual message that the snapshot
has either not been created or has been cleared appears.
> Despite the error message, the snapshots can still be applied so its
really just an irritant and a worry that if something is wrong it may cause
other undetected problems.
> Has anyone got any idea how I can correct this please?
|||The problem is that EM is looking for explorer.exe in all the wrong
places. I had the same problem and ran filemon while trying to
Explore the snapshot folder from enterprise Manager. Below is what I
found:
mmc.exe:3964 OPEN C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\explorer.exe FILE NOT FOUND
mmc.exe:3964 OPEN C:\WINNT\system32explorer.exe
FILE NOT FOUND
I copied Explorer.exe from c:\winnt to both c:\winnt\system32 and
C:\Program Files\Microsoft SQL Server\80\Tools\BINN\
Works like a charm now.
Hope this helps.
Randy
"Hilary Cotter" <hilaryk@.att.net> wrote in message news:<#AxyiCJeEHA.2376@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> are you using dynamic filtering?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Bruce Thomas" <Bruce Thomas@.discussions.microsoft.com> wrote in message
> news:28CCE323-2AFF-4D7F-86FE-9EE3E8AAE9DC@.microsoft.com...
> Specified File Was Not Found" when I use the Explore Snapshot button or the
> Explore the Latest Snapshot Folder menu item.
> files are in fact present and sp_browsesnapshotfolder and
> sp_browsemergesnapshotfolder each return the correct path.
> has either not been created or has been cleared appears.
> really just an irritant and a worry that if something is wrong it may cause
> other undetected problems.

No comments:

Post a Comment