Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

HELP! I deleted the log files for my db. I need to restore

The drive holding the logs was full w/ 60 gigs of logs.

I stopped the db and deleted the log files. Now i'm hosed Please help. No drive restore avail.

I still have the mdf files. I tried to detatch the db but can't due to log on error, tried to delete the db after moving the mdf file, unable due to log on error.

In a perfect world i would delete the db. Create a new one w/ the same privs and then replace the newly created mdf file.

Thoughts?

Please help

when I try to delete i get the following.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Failed to connect to server sql. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot open user default database. Login failed.
Login failed for user 'path\user'. (Microsoft SQL Server, Error: 4064)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476
0
priehl
Asked:
priehl
  • 2
1 Solution
 
SvenCommented:
There is no hope for you I think. We had a similiar problem a few weeks ago when our raid system crashed completly and did not restore itself. We tried to restore the database with the .mdf and .ldf files, but this is not working even some user got this working in sql versions before 2000!

We luckily got the raid system working and restoring after a day or two and so could rebuild the data by restoring backups and logs.
0
 
moondistCommented:
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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