Re: HELP! Out of Space

Dale E. Reed Jr. ( (no email) )
Thu, 30 Apr 1998 12:04:09 -0700

Michael Whisenant wrote:
>
> Hello again,
>
> Here is the -x15 debug information:
>
> "Can't allocate space in object 'Calls' in database 'Emerald' because the
> 'default' segment is full."
>
> I need to expand the device, so I can expand the database, I have been
> looking in the SQL books to get the command, because the partition is
> larger than 2GB and the Sql manager will not work.

This is from the TSQL docs. You can get it by selecting Transact
SQL Help from the HELP pull down menu in isql_w or Enterprise manager.

DISK RESIZE
NAME = logical_device_name,
SIZE = final_size
where

logical_device_name
Specifies the database device to resize.
final_size
Is the final size to which the device should be expanded, specified in 2K
pages.

Remarks

Examples

A. Increase the Size of a Device

This example increases the size of DEVICE1 from it's initial size of 12 MB to 20
MB.

DISK RESIZE
NAME = 'DEVICE1',
SIZE = 10240

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com