>>>>truncate it or shrink it...
>>
>>Here's a very quick and very dirty way to truncate the log.
>>In database properties/option change recovery model to simple.
>>From the context menu select All Tasks/Shink Database.
>>Definitely not the text book way, but it's gotten me out of a few scrapes when the log file had become huge.
>
>>>That worked...the part I was missing changing the recovery model....
>>>Thanks!
>
>Glad it helped.
>
>If you want to take advantage of the log in the future, change the reoovery model back to full and put in a backup procedure that will take care of shrinking the log for you.
...That's excatly what I've done.
Thanks again!
ICQ 10556 (ya), 254117