I'm backing up an analysis services database to an abf file and then restoring it to another database, with a different name, on the same server. However, when I process the database that I originally backed up, the cubes in the restored database are deleted?
I can only think that the objects in the database have a unique identifier and these are the same in both databases, and when I process the original database it's deleting both sets of cubes, but only rebuilding the ones in the database I'm processing.
The only way that I can think of out of this is to restore the database to another server, which I don't want to do.
Any ideas would be much appreciated.
This sounds like a bug. There is a special code during restore which is supposed to change the unique ids you refer to in order for them to stay unique. Sounds like for whatever reason in your scenario this code doesn't work.
No comments:
Post a Comment