i am running ver 1.2. i do not have any journals. all receipts were deleted. i did shrink the journal table using this commond- truncate table journal. i am confused because my only available space is 607.78 mb- usage 69% from a data base size of 1940. mb. can some one explain why my available space is so small.
dexter
hi Dexter, what you have done, now the one thign you can do to restore this table, as you already run the trucate command which remove all the data from journal table, you must first contact any of us and ask what to do then do the job but as you done there are couple of way you can do so.
Restore the data with old backup if you have taken before performing the operation.
OR Restore the new database with new name and export the journal table to your live database. Now sure how you handle this but if you need any help feel free to come > i am running ver 1.2. i do not have any journals. all receipts were deleted.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required