As it didnt matter about the transaction data being lost in this case. I dettached the Database using sp_dettach_db, deleted the log file from within explorer and then ran...

Cheers for all this info guys i am going to try the suggestions today so i will get back to you with what worked.