Transaction Logs 1

[rat22]

I am having problems truncating my transation logs.
I have logs in excess of 40 gigs and the BOL is very vague on the truncating of them. Any help would be helpfull

Regrads

Rat22

 

[Cagliostro]

detach the tatabase by using exec sp_detach_db 'dbname', delete the log file and attach it again by using exec sp_attach_db 'dbname', 'path'. The log file has the extention .lds and the database .mdf John Fill

ivfmd@mail.md

 

[rat22]

That method, tested on a test database, created a usless database that I cant even delet now becuae i cant reattatch the file. I unattateched it and deleted the log file, tried to recreate the file and reatatch and got the error
Server: Msg 823, Level 24, State 10, Line 1
I/O error 38(Reached end of file.) detected during read of page buffer.

Connection Broken

any other suggestions?

 

[tlbroadbent]

Check the following links for the correct way to shrink a transaction log.

http://support.microsoft.com/support/kb/articles/Q272/3/18.ASP

http://msdn.microsoft.com/library/en-us/architec/8_ar_da2_1uzr.asp

http://www.swynk.com/friends/krishnan/tranlogshrink.asp

faq183-345
Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.