I'm trying to restore a database - one that I made changes to locally and then uploaded. I'm getting the following error on restore: Restore failed. The database backup file contains more than one data file. You cannot restore a backup with more than one data file. I'm not sure how it could have more than one data file...? It was restored locally, modified, and then backed up.
You will need to check if your database is set to have two types of data file attached to them. If you go to your local database right click on it and click on Properties/Files you should see two paths to a data file. One of them will have to be dropped.
Thanks Ray. I think something else was wrong. I ended up deleting the database, recreating it, and then restoring it with the same file and it worked fine.
Hi, I have the similar issue when restore the database using backup created on local machine. I followed the naming convention and make sure the bak file is in the AppData folder. My Error message: Restore failed. Please contact support for details. Please advised.
