Link to home
Start Free TrialLog in
Avatar of priehl
priehl

asked on

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
Avatar of Sven
Sven
Flag of Germany image

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.
Avatar of moondist
moondist

ASKER CERTIFIED SOLUTION
Avatar of moondist
moondist

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial