1. Home
  2. Database
  3. SQL Server
  4. SQL Server Error Messages
  5. “Restore failed for Server ‘[Server and SQL Instance]’. System.Data.SqlClient.SqlError: Cannot find file ID 2 on device…” – SQL Management Studio

“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

Updated on August 2, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support