troubleshooting Question

Sybase sp_helpdb and sysusages show incorect space usage

Avatar of maria_rossi
maria_rossi asked on
Sybase Database
5 Comments3 Solutions5733 ViewsLast Modified:
Hi,

Sybase sp_helpdb shows  for 'data only' that 'free kbytes' is almost the same as the size,  So, it seems that the database does not have any data.  But we do know that it has data  because many tables returned xxx rows.    Sysusages also shows the unreservedpgs is the same as  the size.  

How can we correct this?    This has been in this state for several days already and the backup that we have probably also has this and I prefer to just correct (if possible), instead of reloading backup.

We have ASE 12.5.2.

Thanks.
Maria
ASKER CERTIFIED SOLUTION
bret

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros