General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Can't allocate space
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only