I have a (LDF) log file that has grown large (>1GB) in proportion to the database (43Mb). I have tried various techniques found in 'Q' articles and other forums to shrink this file but without success. Any ideas?
The script Steve referenced is terrific. A cheap hack is to detach the db, delete the log file, then use the sp_attach_single_file_db proc to reattach, it will generate a new log file.