HELP! Corrupted TLOG File

[CRAMan]

Ok I just started this new job.

I had a databse go down today, I am trying to bring it back up. The log file is corrupted. The MDF Is good. How can I attach the MDF without the LDF file?

 

[SQLBill]

Check out the Books OnLine (and do a search on this forum) for sp_attach_single_db.

You can execute that stored procedure to load just the .mdf file. Or better yet (and easier) you can use Enterprise Manager. Right-click on the server, select All Tasks, then select Attach Database. Browse to the database file location and select the .mdf file. Make sure that only the .mdf file is checked in the popup window. Then set the database owner, select verify and then OK to attach.

-sQLBill

 

[CRAMan]

When I try to attach just the MDF it gives me a red X next to the LDF file and looks for it

 

[CRAMan]

It gives me a device activation error, File not found for the ldf

 

[SQLSister]

use QUery analyzer and run the sp_attach_single_db in it. Look up the proper parameters and execution for the stored procedure in Books online.

 

[CRAMan]

I tried the Query analyzer. What happened is the server crashd, the Database wasnt properly detached. This is my firstday ya!

 

[CRAMan]

Here is my error

Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'E:\MSSQL\SalesLogix_Log.LDF' may be incorrect.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'SalesLogix2'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'E:\MSSQL\SalesLogix_Log.LDF' may be incorrect.

 

[SQLBill]

Did you have a backup of the database?

-SQLBill

 

[tlbroadbent]

Rename the corrupted LDF file and then use sp_attach_single_file_db to attach the mdf file. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm