![]() Much of this material is reprinted from the Backup and Data Recovery chapter of the SA Usage manual, with permission from Sybase, Inc. The following topics include how to recover data entered since the most recent backup and how to backup up a running database. The current document discusses advanced topics that will be of particular interest to those running the system in larger organizations with high data entry volume. ![]() The information in the Backing Up Your Data article is quite sufficient for most installations. Posted in Attachments, Database Maintenance, G4, Storage | Tagged attachment, Backup, database, storage Impact on performance of the database should be negligible, assuming appropriate amounts of RAM for the size of your database and modern disk drives. You also enjoy the benefits of greater security, the convenience of having the attachment information in a handy location, and the peace of mind that your attached documents are backed up along with the rest of your SOS data, with no need for any change in backup strategy or configuration. (FYI: Documents in pdf format, and graphics in jpg format, for example, are already compressed, so they will take up approximately the same amount of space in the SOS database as they do outside of it.)īottom line is that if you use the option to delete the originals after importing, the net storage used will be less than if you just saved the documents separately on your hard disk or network. Attachments are all compressed using the standard zip compression algorithm before being imported into the database, so anything that is not already in a compressed format will be significantly reduced in size when stored in the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |