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.Conne ctionInfo)
-------------------------- ----
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
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.Conne
--------------------------
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
This article seems to address your situation.
http://blog.spaceprogram.com/2002/06/recovering-from-deleted-log-file-on_12.html
http://blog.spaceprogram.com/2002/06/recovering-from-deleted-log-file-on_12.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.