HELP! Major LDF Problem...

I hope I haven't messed up! I was importing some data, and it started taking too long and seemed to have locked up, I did a cold boot and when I tried to open the db it would just load...

I have then detached it and tried to reattach the db, but it seems to just load forever.. I let it sit there for an hour and still nothing...

the DB has a 17gig LDF file and I can't attach without it...

PLEASE HELP!Resolved!

I went in auto-recovery mode..|||do you ever backup your db's ??

a 17GB LDF seems a little hefty.

in auto recovery, SQL was playing back all the transactions from the log. thats probably why it took sooooo long.

run a full backup and then shrink the db. you should be able to get the ldf quite small after a shrink.