6.5 was a long time ago ...

you should be able to expand the log file onto the new drive. Check the BOL for specifics.

-Mike

>Novice MS SQL User
>
>Dell PowerEdge 2300
>NT 4 server SP4
>MS SQL Server 6.5
>
>i'm trying to upload 250,000 records
>
>Error : 1105, Severity: 17, State: 2
>Can't allocate space for object 'Syslogs' in database 'clearance_data' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
>
>what i'm planning to do is to add a new hard drive to the server, but HOW?
>
>please help
>
>NT Server Setup
>
>4338MB DISK 0 C: - 1083MB Mirror Set E: - 3240 Stripe Set
>4338MB DISK 1 C: - 1083MB Mirros Set E: - 3240 Stripe set
>4299MB DISK 2 F: - 4299MB Primary Partition
>
>
>SQL Server Setup
> Database devices Data Size Available
> clearance_device 5500MB 1290MB
> DATA2
> master
> MSDBData
> MSDBLog
> Databases
> clearance_data
> master
> model
> msdb
> pubs
> tempdb
>
>Thanks in advance