Sql-server – How to resolve the error “The file exists” when restoring a cube backup

sql serversql-server-2005sql-server-2008

I'm trying to restore a cube backup (a .abf file) using SQL Server Management Studio, but I'm getting the error message:

The following system error occurred: The file exists. . (Microsoft SQL Server 2005 Analysis Services)

(yes, there really are two dots)

Does anyone know how to resolve this so I can restore the backup?

Here are the steps I'm using:

  • Open Microsoft SQL Server Management Studio
  • Make the connection to the AS server
  • Right-click on the Databases node on the server tree view
  • Choose Restore...
  • Type in a new database name in Restore database
  • Select the backup file in From backup file
  • Enter the correct password
  • Optionally tick Allow database overwrite (it happens both ways)
  • Press OK –> get the above error message

Best Answer

Well, it seems that the reason for the problem is that the backup was of a SQL Server Analysis Services 2008 cube. I'd have preferred a nice simple "This backup is not compatible with this version." error message, but hopefully this question will help anyone else with this problem in the future!

In case you're wondering, this backup was from a customer that I thought was running AS2005, but was actually running AS2008.

Related Topic