• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

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?
0
bemara57
Asked:
bemara57
1 Solution
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now