Sorry it wasn't clear, but I was always planning to do a restore after the backup.
You are saying I can do a backup with garbage collection off (it will run quicker) and a restore and this will shrink my database.
Wonderful!
Thank you for all your help.
Thank you!
The goal is to reduce the size of the database. As long as I know the backup with garbage collection is working, I will schedule time to allow it to finish.
I am having problems deleting 1.6 million records from my Interbase 4.0 database. The records contain BLOB data.
A backup run before the deletion completed in an hour. After the deletion, the backup ran for four hours and then I had to kill it. I ran data validations before and after the...
I am trying to copy from a memo field in an Interbase table to a memo field in a Paradox DOS table. Using an insertrecord command copies the data correctly except that the #13#10 is copied as well. This shows up as a music note at the end of every memo entry.
I have tried other methods to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.