Restore with backup & migrate module does not work with Acquia Dev Desktop
There could be many reasons for this not working for you but as long as you've got the database backup and a copy of your existing codebase, you should be fine. Fixing DevDesktop database issues is a little tricky but the easiest way is to just create a new instance with the correct settings. Quick steps to do this:


We're going to be deleting the whole site instance using DevDesktop so you should make a backup of the folder and your database backup or at least move it outside of the DevDesktop folder.
Now from the DevDesktop application, delete your site and then create another one with the same name, etc. This will create a new database and a new settings.php file that is connected to it.
Finally, you'll want to copy your codebase back into this directory
(making sure not to overwrite the settings.php or sites.php files
that DevDesktop created) and then try the restore again using backup
&amp; migrate.