“Restore failed for Server ‘[Server and SQL Instance]’. System.Data.SqlClient.SqlError: Cannot find file ID 2 on device…” – SQL Management Studio

Summary

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.

Explanation

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.

Solution

Follow the instructions in the Restore a SQL Database from a Backup File related article (link below).

Additional Comments

Related Article: KBA-01228-K0X1W5  Restore a SQL Database from a Backup File

Error First Appeared: Windows 7 running Microsoft SQL Management Studio 2008R2

Author


Was this article helpful?

Related Articles