How do I resolve the error "The file exists" when restoring a cube backup?
- by Ant
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