Windows 2000 2 GB file limit

Nancy Palmquist nlp at vss3.com
Thu Nov 4 13:10:08 PST 2004


Don Coleman wrote:

> Fairlight wrote:
> 
>> Only Kenneth Brody would say something like:
>>  
>>
>>> Don Coleman wrote:
>>> [...]
>>>   
>>>
>>>> evening.  Last night the key file the reached Microsoft 2GB file size
>>>> limit which stopped the archive process.  I renamed the file 
>>>> temporarily
>>>> and set up a new key file and ran the archive process this morning but
>>>> would like to access the now-unavailable archived key.  I can obtain
>>>> Tuesday night's key file from their backup but would still potentially
>>>> be missing some data from Wednesday.  Does anyone have any suggestions
>>>> on how to allow filePro to access this key file.
>>>>     
>>>
>>> [...]
>>>
>>> Use extended key files -- key, keyx1, keyx2, and keyx3.
>>>   
>>
>>
>> Out of curiosity, define "use".  touch/chown/chmod?  Or is there 
>> something
>> more to it?  You'd think if fP has the ability to use them, it would 
>> create
>> them on its own, so I'm wondering what you mean by "use".
>>
>> Do they supplement the main key, or replace it?
>>
>> mark->
>>  
>>
> Mark:
> 
> By "use" I mean access via filePro.  Ideally I would like to be able to 
> delete several records to get the file size below the MS limit (~2GB).  
> At this time fP nor any other MS based programs can access the file 
> including a both hex and text editors.  I know that deleting several 
> records will not reduce the actual file size until that space is 
> reclaimed.  That will be the next challenge.  I was hoping to delete the 
> last several records with my hex editor but it is unable to open the 
> file.  I do need to be able to view and access this data occasionally.
> 


Don,

I have found it helpful to archive data by year, creating a new file 
each year  (key99, key00, key01, key02, etc.)  This limits the size, 
allows very old data to be dropped by just deleting the year in 
question, and makes finding stuff easier.

Do you have the key from the two files from before the last posting started?

The key can be transferred to a UNIX or LINUX and bytes can be removed 
or added.  I haven't done it in a long time, but as I recall there is a 
command that can grab x bytes from the front or back of a file and it 
can then be streamed to a new filename.

You need to calculate the number of bytes.

(filesize or 2 gig) /(Record length + 20)

Take the integer part of this number and multipy by (record length + 20).

That number is how big the file must be to be less than 2 gig.

Hope someone can post the command.  My memory is hopeless for this.

Nancy

-- 
Nancy Palmquist
Virtual Software Systems
PHONE: (412) 835-9417			Web site:  http://www.vss3.com



More information about the Filepro-list mailing list