Solved

CAnnot restore my DB

Posted on 2004-09-01
9
472 Views
Last Modified: 2008-01-09
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
Comment
Question by:romeonyc77
  • 6
  • 3
9 Comments
 

Author Comment

by:romeonyc77
Comment Utility
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
 
LVL 10

Expert Comment

by:imrancs
Comment Utility
Restore DB dialog > Options Tab

Check the "Force restore over the exiting database"

Imran
0
 
LVL 10

Expert Comment

by:imrancs
Comment Utility
if you have backup of database then trying to delete database first and then Restore.
0
 

Author Comment

by:romeonyc77
Comment Utility
From enterprise manager, i would need to create it first correct? then restore it?
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 10

Expert Comment

by:imrancs
Comment Utility
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
 
LVL 10

Expert Comment

by:imrancs
Comment Utility
and press OK
0
 

Author Comment

by:romeonyc77
Comment Utility
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
 
LVL 10

Accepted Solution

by:
imrancs earned 50 total points
Comment Utility
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
 
LVL 10

Expert Comment

by:imrancs
Comment Utility
Glade if I could help.


Imran
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now