log_reuse_wait_desc

Last week I got a production call on transaction log full. hmmm there was no chance for that database log to get filled. I was wondering and when I looked into the database it said the transaction log is waiting for the replication to complete. I was like whatttttttttttt, since I had a replication build earlier and dropped it as it didnt work out good.

Then after doing some research I found out like there is a bug with the SQL 2005 in which even if we remove the replication, it doesnt remove it clearly. This issue was discovered in CTM and we are currently in SP1, the issue exists till now. It is being discussed in this MSDN form . It was really too scary ouchhhhhhhh.