[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Compact Database?

Posted on 2004-08-11
3
Medium Priority
?
671 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 375 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

An overview of cyber security, cyber crime, and personal protection against hackers. Includes a brief summary of the Equifax breach and why everyone should be aware of it. Other subjects include: how cyber security has failed to advance with technol…
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

650 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