InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 22:59:47 GMT20http://www.sqlservercentral.com/Forums/Topic1381951-391-1.aspxDoes anyone know if SQL Server takes into account the size of the backup file it is overwriting in the case of backing up an SSAS database?Scenario:SSAS Version: 10.50.2811Existing backup: SSASDatabase.abf 65.2GBFree Space on Drive: 99GBXML: [code="xml"]<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>SSASDatabase</DatabaseID> </Object> <File>\\Share\Folder\SSASDatabase.abf</File> <AllowOverwrite>true</AllowOverwrite></Backup>[/code]This fails with an insufficient space error. To make the job run successfully, I delete the existing backup and run the job from this step. The initial file size before compression now is 117GB! More than double the final result of 65.2GB. Question 1: Is the XML correct for this? (a developer wrote this and I am not too familiar with doing these backups)Question 2: Does it not take into account the space of the file being overwritten as free space? This seems probable, given the error. However, I would like to know if this can be verified. (I've googled, but my google foo on this is lacking)Any help would be appreciated!Wed, 07 Nov 2012 06:36:43 GMTSQLKnowItAll