Solved

Compact Database?

Posted on 2004-08-11
3
576 Views
Last Modified: 2008-02-26
I have used foxpro before and we used the "zap" command to compact the databases.  Is there a similar command in sybase or is it even necessary for a sql database?
0
Comment
Question by:vcab
  • 2
3 Comments
 
LVL 14

Expert Comment

by:Jan_Franek
ID: 11771995
What Sybase database server do you have - ASE (Adaptive Server Enterprise) or ASA (Adaptive Server Anywhere) ?
0
 

Author Comment

by:vcab
ID: 11772178
Adaptive Server Anywhere 7.0.2.15
0
 
LVL 14

Accepted Solution

by:
Jan_Franek earned 125 total points
ID: 11772360
Well it is not necessary to compact ASA database. However, sometimes it's good to create new clean database and then there are same useful utilities like rebuild or dbunload. For detailed info you can check http://sybooks.sybase.com/onlinebooks/group-aw/awg0700e/dbrfen7/@Generic__BookView;lang=cs
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now