abf backup of the AdventureWorks 2005 OLAP cube. abf file can be recovered? In order to assist in troubleshooting I have created two copies of an. abf backup files, but they are all corrupted because they have been copied to this location. The problem that we have is that we lost one of our cubes and need to be able to restore from one of our. bak files - they still restore successfully after being retrieved from this location. (Interesting point aside is that this network location does not seem to corrupt. We now back up to a different location which we have tested, and confirmed that this location do not cause corruption. We know now that it is the particular location that we backed the files up to that causes this corruption, as we can consistently replicate this. TITLE: Microsoft SQL Server Management StudioĮrrors in the compression library: The data could not be decompressed. At this point, the restore fails with the following error message: When it is required to restore a backup, we copy the backup file back to the local HDD for restore. We then move the backup file to the NAS as this is our usual backup storage area. abf backup of an OLAP cube on the local HDD and test restore the backup, it restores successfully. We have done testing, and found the following: We back up our Analysis Services cubes to a NAS, and have recently found that all our backups have become corrupted.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |