Solved

recovery of database with missing ldf

Posted on 2000-03-27
4
263 Views
Last Modified: 2008-03-10
A database is considered suspect after a disk full error.  The ldf file to it is missing.  When select TABLES foar athe database I get an error 945.  How can I render this database useful again?  
0
Comment
Question by:beachbum714
  • 2
4 Comments
 

Author Comment

by:beachbum714
ID: 2662119
Adjusted points from 100 to 150
0
 
LVL 32

Accepted Solution

by:
bhess1 earned 150 total points
ID: 2662143
See "Resetting the Suspect Status" and "Insufficient Disk Space" in SQL Server Books Online.  And be careful!
0
 
LVL 6

Expert Comment

by:crsankar
ID: 2662963
The only solution that I can think of, is to restore the database from a valid backup.
0
 

Author Comment

by:beachbum714
ID: 2664831
Thanks for the help.  Nothing has worked.  Though I have reproduced the major tables, I wish I could save the lookups.  
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

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

760 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

20 Experts available now in Live!

Get 1:1 Help Now