I'm covering on a site that has SQL 6.5 (I'm very new to SQL) running a
Great Plains Dynamics Accounts database.
I've read as much documentation that I can get my hands on which has been
mostly online, but it seems to mostly concern the inital setup of SQL and
not the daily maintenance and care of the databases.
I'm getting this error in the NT Application Log and a variation with
Error : 1105, Severity: 17, State: 1
Can't allocate space for object 'GL10001' in database 'PLAY' because the
'default' 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.
The database size is 225Mb is with approx 20Mb free space according to SQL
Enterprise manager, the log is on it's own device and is 100Mb with 99.97Mb
Could anyone explain what the '"default" segment' is that is referenced in
Is it simply a case of expanding the database? The main person responsible
for the input of data seems to think that the database size occupied is
much greater (200Mb) than the data that has been input (4 mnths of data),
which used to occupy alot less space on the old system (Approx 3Mb).
Also can anyone explain how to check to see where a transaction log is
Separate devices have been created for the logs but I cannot see that the
devices are actually being used.
Thanks for any help
Please reply only to the group when replying.