• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

CAnnot restore my DB

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
0
romeonyc77
Asked:
romeonyc77
  • 6
  • 3
1 Solution
 
romeonyc77Author Commented:
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.
0
 
imrancsCommented:
Restore DB dialog > Options Tab

Check the "Force restore over the exiting database"

Imran
0
 
imrancsCommented:
if you have backup of database then trying to delete database first and then Restore.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
romeonyc77Author Commented:
From enterprise manager, i would need to create it first correct? then restore it?
0
 
imrancsCommented:
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.
0
 
imrancsCommented:
and press OK
0
 
romeonyc77Author Commented:
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?
0
 
imrancsCommented:
select the "From Device" option button
Press the [Select Devices...] button
Press the [Add...] button  and brows for backup file
and then press OK and OK :o)


Imran
0
 
imrancsCommented:
Glade if I could help.


Imran
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now