shrink database device

[Former Member]

Hello all,

I know that with Sybase ASE 15.7 you can shrink log space with the following command (example for the saptools):

alter database saptools log off logsaptools_1 = '200M'

I have tried it out and it works fine.

Is there also a possibility to shrink the device logsaptools_1 afterwards?

Kind regards,

Thomas

[former_member612721]

Did anyone manage to shrink ASE devices and release the space back to disk ?

I am in single user mode, and saptools has a new device allocated I can't manage to take all the space from the device sybbaldrdev due to the below error:

1> alter database saptools off sybbaldrdev='7M'
2> go
Msg 5072, Level 16, State 1:
Server 'NIC', Line 1:
ALTER DATABASE cannot remove the first 256 pages of a database.

I'm now trying to deallocate device sybbaldrdev from database saptools, and allocate to the new device.

Shouldn't the DB rearrange the pages to use the new device automatically?