How do I work around '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.