Msg 9002 - Unfinished procedure
Posted on 2004-10-06
I ran the following procedure on a database which has about 25 million records. For each record, there's a ticker name and some have ~del as their suffix which I want to replace.
set ticker = replace(ticker,'~del','_')
then after 10 hours, I got this message.
Server: Msg 9002, Level 17, State 2, Line 2
The log file for database 'AIQ' is full. Back up the transaction log for the database to free up some log space.
I checked the collumn and it looks to me like the procedure was not completed. I have two questions regarding this.
1. Must I run the whole procedure again? Perhaps the procedure really was done and I'm not seeing it.
2. Is there a way to run this procedure more quickly?
Also, I detached the database then manually deleted the log by going into explorer and dragging it to the recycle bin, then reattached the database.
3. Is this an okay way to go about this?
4. How can I be sure the log won't fill up again? (I'm not sure how big it was when I started.
THANKS A TON FOR ANY HELP!!! I really appreciate it. I setting this at 500 points because it's really several questiions.