Transaction Size increases

• Ather M

  SSChasing Mays

  Points: 607

  More actions

  March 26, 2010 at 3:08 pm

  #220458

  I am running the stored procedure where it includes bulk insert for many tables.

  I have a question why the DB size increases so much say around 3+ GBs ?

  What is the solution for that ?

• GTR

  SSCrazy Eights

  Points: 8007

  More actions

  March 26, 2010 at 3:45 pm

  #1140803

  What is the recovery model of the database? Check this article it explains reasons for growing log.

  http://www.mssqltips.com/tip.asp?tip=1185

  EnjoY!

• Ather M

  SSChasing Mays

  Points: 607

  More actions

  March 29, 2010 at 3:12 pm

  #1141748

  Thanks for your reply....

  I will check the link and let you know