<div>
see<br />
Step-By-Step: Learn how to restore databases in Microsoft SQL Server<br />
<a href="http://techrepublic.com.com/5100-6268-1041267.html#" rel="ugc">http://techrepublic.com.com/5100-6268-1041267.html#</a><br />
---<br />
in figure B - make sure the Restore as point to real (on the server Drives and folders)<br />
if not create or point (type) good path<br />
and check (check &nbsp;box)<br />
&nbsp;'Force restore over existing'
</div>


<div>
<div class="content wysiwyg-content">
I honstly dont realy know enything about sql, but someone has sent me a backup of a database they wan't me to restore over a databse on our sql server. there backup file is caled 'Blankincase5.bak' and they wont me 2 overight a databse called 'BenefitsInCase5'. i've got to the restore screen on EM and once i have selected 'BlankInCase5.bak' as the file i want to restore from. when i click ok i get the cannont find file id2 on device &quot;path to file&quot;. could some one help me restore the file please? i had a thought that i might be because it was backed up from someone elses database, might be wrong but i should mentioon the 2. 
</div>
</div>


I honstly dont realy know enything about sql, but someone has sent me a backup of a database they wan't me to restore over a databse on our sql server. there backup file is caled 'Blankincase5.bak' and they wont me 2 overight a databse called 'BenefitsInCase5'. i've got to the restore screen on EM and once i have selected 'BlankInCase5.bak' as the file i want to restore from. when i click ok i get the cannont find file id2 on device "path to file". could some one help me restore the file please? i had a thought that i might be because it was backed up from someone elses database, might be wrong but i should mentioon the 2. 

see
Step-By-Step: Learn how to restore databases in Microsoft SQL Server
http://techrepublic.com.com/5100-6268-1041267.html#
---
in figure B - make sure the Restore as point to real (on the server Drives and folders)
if not create or point (type) good path
and check (check  box)
 &#39;Force restore over existing&#39;

problem restoring database (cannont find file id2)

I honstly dont realy know enything about sql, but someone has sent me a backup of a database they wan&#39;t me to restore over a databse on our sql server. there backup file is caled &#39;Blankincase5.bak&#39; and they wont me 2 overight a databse called &#39;BenefitsInCase5&#39;. i&#39;ve got to the restore screen on EM and once i have selected &#39;BlankInCase5.bak&#39; as the file i want to restore from. when i click ok i get the cannont find file id2 on device &quot;path to file&quot;. could some one help me restore the file please? i had a thought that i might be because it was backed up from someone elses database, might be wrong but i should mentioon the 2. 

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.