I hope this hasn't been raised before. I have been asked to manage a database of around 55,000 records on a Maximizer 6 client/server installation. On Friday I performed a backup and attempted an optimised restore. This ostensibly worked for everything except the Notes records (which have been shown this problem almost since we first installed Maximizer in January 2000) - these I restored without using the Optimised Restore Method. After I was done, I tested everything and it seemed fine according to my quick tests. However, other users could not log in to the database this morning as they were getting an error message of Code 30 on the UDF file (unfortunately they did not preserve the exact wording of the message for posterity). Due to time restrictions I just copied the database files from my manual backup folder over the top of the live database files and everything was fine. However, I am concerned about a couple of things.
Firstly, is there any way that I can get the Notes and UDFs cleaned up so that I can use the optimised restore method (the UDFs table has over 1,000,000 entries now)? Secondly, is there any way I could have told that the optimised restore of UDFs did not work, given that there were no error messages? While the database seems to be performing well enough for now, I am not comfortable with the idea of leaving it for too long without maintenance. If anybody has come across these problems I would be very grateful for any advice you can give.
Thanks,
Andrew
Original Post