Wednesday, March 21, 2012

Deleting binn files

I'm running a copy of SQL-Server v7 on a win2k machine,
and I've run into the problem of files randomly
disappearing from the \80\tools\binn directory. So far,
over 40 files have gone missing from the binn dir,
including all the files and dlls to run dtsrun and the
query analyzer. Has anyone ever seen this kind of
behaviour on their sql installation, or know what causes
it?
btw, I'm running sp3 on the system.
-IanOops, I accidentally made a mistake with my post... the
version of SQL that I'm running is actually SQL 2000...
does that affect the nature of the problem?
I appreciate your help w/ this problem.
>--Original Message--
>\80\tools\binn directory is for SQL 2000 not for SQL V7.
>It is very unlikely to be deleted these files randomly.
>Because, if you are running these application and if you
>try to delete these dlls, you get access violation.
>If you are running multiple instances for example SQL 7
as
>default, SQL 2000 as second instance, then there is a
>possibility of some files taken out from one of these
>directories(particularly common resources for both
>instances). This happens only when the installation
>process for 2 instances are not done properly.
>Chinna.
>>--Original Message--
>>I'm running a copy of SQL-Server v7 on a win2k machine,
>>and I've run into the problem of files randomly
>>disappearing from the \80\tools\binn directory. So far,
>>over 40 files have gone missing from the binn dir,
>>including all the files and dlls to run dtsrun and the
>>query analyzer. Has anyone ever seen this kind of
>>behaviour on their sql installation, or know what causes
>>it?
>>btw, I'm running sp3 on the system.
>>-Ian
>>.
>.
>|||I have more info on the actual files that were deleted...
I compared the contents of the binn directory to another
machine running a similar installation of SQL 2000, and
these are the files that appear to be missing:
colctrl.dll
dmcomscm.exe
dtsrun.exe
dtsruni.exe
dtswiz.exe
hhsetup.dll
isql.exe
itwiz.exe
odbccmpt.exe
psdcscm.dll
replmon.pmc
sqlbrows.cnt
sqlbrows.hlp
sqldmo80.cnt
sqldmo80.hlp
sqldts80.cnt
sqldts80.hlp
sqlftwiz.exe
sqllex.dll
sqlmmmem.chm
sqlmmcii.chm
sqlns80.cnt
sqlns80.hlp
uncol.exe
wiztrace.exe
Once again, thanx for your help on this...
-Ian
>--Original Message--
>I'm running a copy of SQL-Server v7 on a win2k machine,
>and I've run into the problem of files randomly
>disappearing from the \80\tools\binn directory. So far,
>over 40 files have gone missing from the binn dir,
>including all the files and dlls to run dtsrun and the
>query analyzer. Has anyone ever seen this kind of
>behaviour on their sql installation, or know what causes
>it?
>btw, I'm running sp3 on the system.
>-Ian
>.
>|||\80\tools\binn directory is for SQL 2000 not for SQL V7.
It is very unlikely to be deleted these files randomly.
Because, if you are running these application and if you
try to delete these dlls, you get access violation.
If you are running multiple instances for example SQL 7 as
default, SQL 2000 as second instance, then there is a
possibility of some files taken out from one of these
directories(particularly common resources for both
instances). This happens only when the installation
process for 2 instances are not done properly.
Chinna.
>--Original Message--
>I'm running a copy of SQL-Server v7 on a win2k machine,
>and I've run into the problem of files randomly
>disappearing from the \80\tools\binn directory. So far,
>over 40 files have gone missing from the binn dir,
>including all the files and dlls to run dtsrun and the
>query analyzer. Has anyone ever seen this kind of
>behaviour on their sql installation, or know what causes
>it?
>btw, I'm running sp3 on the system.
>-Ian
>.
>

No comments:

Post a Comment