Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backing up SSAS Database; Insufficient space Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2012 6:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 2,691, Visits: 3,375
Does 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.2811
Existing backup: SSASDatabase.abf 65.2GB
Free Space on Drive: 99GB
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>

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!


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1381951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse