Is there a way to find out what filled up the Transaction Log?

I have SQL Server 2008 and yesterday my transaction log was 60mb, now its 35gb in one day! Is there a way to find out what did this so I can correct the problem?
bemara57Asked:
Who is Participating?
 
RiteshShahCommented:
well, there is no direct way to read transaction log, you may get some help from any 3rd party tools like red-gate tool belt. otherwise, you are out of luck, generally bulk operation flood the transaction log much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.