Resolving error 'Restore failed for Server 'servername\instancename'.
Restoring a backup of a database to a new database may return an error message in newer versions of SQL Server.
Users may receive the following message when restoring a database backup to a different database in Acctivate Database Maintenance.
Restore failed for Server {servername\instance}. --> To accomplish this action, set property Database.
This message is typically returned when the backup file contains a backup set for a different database. Restoring a copy of your live data to your MODEL company, for instance, could cause the error to be returned.
The simple workaround is to use SQL Server Management Studio to restore a backup to a different database. Take a look at this guide on accomplishing this task.