<div>
The exact error message i get is this:<br />
Error 5170: Cannot create file &lt;.ldf path&gt;because it already exsists. CREATE DATABASE failed. some file names listed could not be created. Check previous errors. 
</div>


The exact error message i get is this:
Error 5170: Cannot create file <.ldf path>because it already exsists. CREATE DATABASE failed. some file names listed could not be created. Check previous errors.

<div>
 Restore DB dialog &gt;&nbsp;Options Tab<br />
<br />
Check the &quot;Force restore over the exiting database&quot;<br />
<br />
Imran
</div>


Restore DB dialog > Options Tab

Check the "Force restore over the exiting database"

Imran

<div>
if you have backup of database then trying to delete database first and then Restore.
</div>


if you have backup of database then trying to delete database first and then Restore.

<div>
From enterprise manager, i would need to create it first correct? then restore it?
</div>


From enterprise manager, i would need to create it first correct? then restore it?

<div>
no need to create, you can directly restore<br />
<br />
Database (rt-click) &gt;&nbsp;All Tasks &gt;&nbsp;Restore Database &gt;&nbsp;Give Name in &quot;Restore as database&quot; and Select the backup file.<br />

</div>


no need to create, you can directly restore

Database (rt-click) > All Tasks > Restore Database > Give Name in "Restore as database" and Select the backup file.


<div>
Check the &quot;Force restore over the exiting database&quot; i dont even see the file to be restored, it was there before, now i dont see it on the list, can i specify where the file is located?
</div>


Check the "Force restore over the exiting database" i dont even see the file to be restored, it was there before, now i dont see it on the list, can i specify where the file is located?

<div>
Glade if I could help.<br />
<br />
<br />
Imran
</div>


<div>
<div class="content wysiwyg-content">
I deleted my transaction log file by accident. Now i cannot restore my db. I had backups but everytime i try to restore it keeps telling me it already exsists. I even tried re-installing the SQL, and its the same thing. Please help
</div>
</div>


I deleted my transaction log file by accident. Now i cannot restore my db. I had backups but everytime i try to restore it keeps telling me it already exsists. I even tried re-installing the SQL, and its the same thing. Please help

CAnnot restore my DB

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.