This Error Message Article explains the Microsoft SQL Server Management Studio error message “Restore failed for Server ‘[Server and SQL Instance]’. System.Data.SqlClient.SqlError: Cannot find the ID 2 on device…” and details how to fix the underlying problem that caused it to appear.
SQL server is trying to restore a backup file over an existing database of the same name in the same SQL instance. Most likely, there is a secondary file with the back up that is missing. Most likely, the back-up and restore process is being performed incorrectly.
Follow the instructions in the Restore a SQL Database from a Backup File related article (link below).
Related Article: KBA-01228-K0X1W5 Restore a SQL Database from a Backup File
Error First Appeared: Windows 7 running Microsoft SQL Management Studio 2008R2