We have a transaction log on a sql database and for some reason it has filled up to 50GB when our live system only has about 2GB. Is there any way I can profile sql or the transaction log to try and find out why this particular one has grown so much?
I would guess that you are not backing up the transaction log. This is not the same thing as backing up the database. I would suggest you back it up at least daily. In a high transaction environment, it should be backed up more frequently, ours is backed up every 15 minutes.