Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't allocate space
Message
From
07/12/2002 05:20:42
Omar Joseph Estrolavio
Philippine National Police
Quezon, Philippines
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Can't allocate space
Miscellaneous
Thread ID:
00730603
Message ID:
00730603
Views:
52
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
Map
View

Click here to load this message in the networking platform