Hi Andy, Dingfelder Andy wrote: > > we intend to use the SAPDB togehter with the SAP Content Server. To this > point ��ve two questions: > > As it is documented, the SAPDB will compress the data stored to it. We�re > using CATIA V5 Rev10 SP3 as our > CAD system and the following file types will be stored on the database > > *.CATPart > *.CATProduct > *.CATDrawing > > Anybody knows, with which percentage these filetypes are compressed?
I'm not sure if a percentage number would help you really, even if I tell you that is is e.g. LZW compression. The compression rate depends heavily on the data source, as you already know, I think. Do you know if the *.CAT*-formats aren't compessed either? > The next question concerns the backup and recovery: > > Sometimes it could happen, that a file is corrupt. > So we need to restore this file from our backup, which will be done using > the ARCServe Backup System. As the > data is stored as a BLOB, it could happen we need only to restore one > record. > But the ARCServ restores only the complete database file. This database file > could have a size of approx. 70 GB, which means > we need the restore the complete 70 GB, only for getting one record back to > our productive database. > > Is there a generally backup and restore concept available, or could anyone > give me some hints, how to do this? > > Thanks for your help! The best would be to restore the backup to the test system (should be done nevertheless from time to time to check the recovery process) and take the missing object from there. I think the SAP DB wouldn't be such a easy to use database if we would offer every obscure data volume manipulation possibilities as offered for some other databases. It might be faster in special situations to recover something, but if you aren't doing this very special recovery trick every day, I bet you will destroy more than fix anything. BTW, there are known backup and restore times of about 200 GB per hour when you use the apropriate hardware. Ciao Ralf __________________________________________________________________ Dr. Ralf Czekalla mailto:[EMAIL PROTECTED] _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
