[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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