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

Can't Backup SSAS DB/Cube Expand / Collapse
Author
Message
Posted Wednesday, October 16, 2013 1:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 7:41 AM
Points: 34, Visits: 547
File system error: The following error occurred while writing to the file '': An unexpected error occurred. .
(Microsoft.AnalysisServices)

I can't get one AS DB to backup successfully. It gets to 2 GB and fails with the above error. Plenty of disk space. I backed it up successfully 6 months ago and it was 1.9 GB.
Post #1505403
Posted Friday, October 18, 2013 8:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 7:41 AM
Points: 34, Visits: 547
In case anyone is interested, the resolution was to script out the SSAS DB, recreate the DB from the script and then process the DB.

There was some data corruption is why the backup would not complete.
Post #1506204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse