<div>
Once the database has been shrunk, you can reduce the device sizes by:<br />
<br />
dump database<br />
sp_dropdevice<br />
disk init new device with smaller size<br />
create database for load<br />
load database
</div>


Once the database has been shrunk, you can reduce the device sizes by:

dump database
sp_dropdevice
disk init new device with smaller size
create database for load
load database

<div>
<div class="content wysiwyg-content">
How to shrink sybase database. and its device size?
</div>
</div>


How to shrink sybase database. and its device size?

Shrink sybase database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.