SharePoint/SQL backups taken with AOFO (Advanced Open File Option) are considerably larger than regular backups.

Article:TECH166067  |  Created: 2011-08-01  |  Updated: 2012-09-27  |  Article URL http://www.symantec.com/docs/TECH166067
Article Type
Technical Solution


Issue



SharePoint/SQL backups taken with AOFO (Advanced Open File Option) are considerably larger than regular backups.


Cause



SQL databases are physically larger than the data held within them. This allows it to expand if required when more data is added. When the backup is done using the SQL agent it will backup the SQL data itself, not the physical files, so any empty space will not be included.

When the Backup is done using AOFO and SQL Agent the Backup Job will backup and show the physical file size of the SQL Database.


Solution



Symantec recommends that SQL backup jobs be run separately from AOFO or ADBO backup jobs because SQL backups made with snapshot technology are considerably larger than regular SQL backups.

 





Article URL http://www.symantec.com/docs/TECH166067


Terms of use for this information are found in Legal Notices