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

recovery of database with missing ldf

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
beachbum714
Asked:
beachbum714
  • 2
1 Solution
 
beachbum714Author Commented:
Adjusted points from 100 to 150
0
 
Brendt HessSenior DBACommented:
See "Resetting the Suspect Status" and "Insufficient Disk Space" in SQL Server Books Online.  And be careful!
0
 
crsankarCommented:
The only solution that I can think of, is to restore the database from a valid backup.
0
 
beachbum714Author Commented:
Thanks for the help.  Nothing has worked.  Though I have reproduced the major tables, I wish I could save the lookups.  
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: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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