Restoring a database backup in .BAK format using SQL Server 2005

In most cases, you will be able to properly restore a SQL Server backup file in .BAK format using SQL Server 2005. But sometimes you will encounter the following error Restore failed for Server ‘YOUR_COMPUTER_NAME’.  (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: Directory lookup for the file "DRIVE:\SQL 2005\MSSQL.1\MSSQL\DATA\<<YOUR_DATABASE_NAME.mdf>>" failed with the operating system error 3(The system cannot find the […]