From: Buck Turgidson on
We have a 4GB file on our server that was created by the SQL Server 'bcp'
command. The file has no owner. Even though I am an administrator, when I
right-click on the file, there is no "Security" tab.

We cannot delete, move, copy the file. The error is "Invalid MS-DOS
Function".

Any idea how I can delete this file on a server that I can't take offline?



From: Pegasus [MVP] on


"Buck Turgidson" <jc_va(a)hotmail.com> wrote in message
news:hoave1$e60$1(a)news.eternal-september.org...
> We have a 4GB file on our server that was created by the SQL Server 'bcp'
> command. The file has no owner. Even though I am an administrator, when
> I right-click on the file, there is no "Security" tab.
>
> We cannot delete, move, copy the file. The error is "Invalid MS-DOS
> Function".
>
> Any idea how I can delete this file on a server that I can't take offline?

Takeown.exe (Windows 7) might be able to deal with it, or xcacls.vbs
(http://download.microsoft.com/download/f/7/8/f786aaf3-a37b-45ab-b0a2-8c8c18bbf483/xcacls_installer.exe).

From: Samuel A Mungujakisa on
To get the "Security Tab", disable "Simple File Sharing". Go to "Folder
Options" in Control panel, and under the "View" Tab, disable "Simple File
Sharing". I'm not sure what version of OS you're using, but this should
provide you with the "Security" Tab you're looking for.
You might want to try the "attrib" command in command prompt to remove any
attributes that may be stopping you from deleting the file.. Simply change
directory to the file location and "assuming the file is file.txt", enter
this command: "attrib file.txt -r -a -s -h" and try deleting it again.

Samuel.

"Pegasus [MVP]" <news(a)microsoft.com> wrote in message
news:%23Tyc0jsyKHA.4492(a)TK2MSFTNGP05.phx.gbl...
>
>
> "Buck Turgidson" <jc_va(a)hotmail.com> wrote in message
> news:hoave1$e60$1(a)news.eternal-september.org...
>> We have a 4GB file on our server that was created by the SQL Server 'bcp'
>> command. The file has no owner. Even though I am an administrator, when
>> I right-click on the file, there is no "Security" tab.
>>
>> We cannot delete, move, copy the file. The error is "Invalid MS-DOS
>> Function".
>>
>> Any idea how I can delete this file on a server that I can't take
>> offline?
>
> Takeown.exe (Windows 7) might be able to deal with it, or xcacls.vbs
> (http://download.microsoft.com/download/f/7/8/f786aaf3-a37b-45ab-b0a2-8c8c18bbf483/xcacls_installer.exe).

From: Buck Turgidson on

I tried xcalc.vbs as well as the attrib commands. but they come back with
"File not found".

This is Server 2003, BTW.

I also tried chkkdsk. It says it can't run because the file system type is
RAW. In DisK Management, it says it is NTFS.

>
> Takeown.exe (Windows 7) might be able to deal with it, or xcacls.vbs
> (http://download.microsoft.com/download/f/7/8/f786aaf3-a37b-45ab-b0a2-8c8c18bbf483/xcacls_installer.exe).


From: Pegasus [MVP] on


"Buck Turgidson" <jc_va(a)hotmail.com> wrote in message
news:hodddk$1pc$1(a)news.eternal-september.org...
>
> I tried xcalc.vbs as well as the attrib commands. but they come back with
> "File not found".
>
> This is Server 2003, BTW.
>
> I also tried chkkdsk. It says it can't run because the file system type
> is RAW. In DisK Management, it says it is NTFS.
>
>>
>> Takeown.exe (Windows 7) might be able to deal with it, or xcacls.vbs
>> (http://download.microsoft.com/download/f/7/8/f786aaf3-a37b-45ab-b0a2-8c8c18bbf483/xcacls_installer.exe).
>

In view of the file system discrepancy you report, I would clone the whole
disk or partition to some other disk, then repartition and reformat it.