(preferred) Use the included live backup utility to make a copy of the database in a separate directory, and backup that copy rather than the running production files in your backup set. Depend on Microsoft Volume Shadow Copy Services (VSS) to snapshot the database when using third party backup software after configuring your system to run the dbvss11 utility as a Windows service, orĢ.
You cannot backup the running database using commercial backup software, so a special procedure must be used.ġ. In some installations, it is desirable to keep the database running 24 hours a day.
Backing Up a Database While It Is Running
Mozypro clear log how to#
The material below explains how to use SA transaction log files to protect your data, how to make backup copies of your database and log files while the database is running, and how to recover after system and media failures. You can read this information directly in the online SA help, accessed from your Start > Programs > SOS Applications menu. 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.
Mozypro clear log pdf#
(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 kommentar(er)
