Home > IT Answers > Storage > Is there are way to shrink sybase database to reclaim physical space at OS?
OracleSybaseSQLServer
15 pts.
 Is there are way to shrink sybase database to reclaim physical space at OS?
Data storage, Data storage management, Sybase, Sybase 12.5.0.2, Sybase Databases
We have a database with 15GB freespace, we want to shirnk it and reduce device size so the physical space can be recliamed at the OS level also. Is it possible?

Software/Hardware used:
Sybase
ASKED: November 24, 2010  9:59 AM
UPDATED: November 24, 2010  2:36 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You can shrink the database in sybase by deleting old records or truncating tables which are not used.

Subhendu Sen
 22,035 pts.
 

Thanks for the update, however deletion and truncation will not shrink the database.

How can we reduce the total database size and device size? For example in SQL Server we have DBCC SHRINKDATABASE command to physically shrink database. In Oracle we can alter the datafile to a smaller size. Similary In Sybase how can we achieve this?

OracleSybaseSQLServer
 15 pts.