Out of Space Issue

• Ghanta

  Hall of Fame

  Points: 3999

  More actions

  March 31, 2008 at 8:49 am

  #180505

  say if I am doing an insert (50 million records) into a table.... when i check it while the query is running I see some records inserted.... however, at the end i have no data... table gets truncated. Is it so because I was out of space (I checked the drives and seems like data drive is running out of space).

  Thanks for ur help.

• Jo Pattyn

  SSC-Dedicated

  Points: 32470

  More actions

  March 31, 2008 at 11:54 am

  #796086

  If your transaction log is full, the whole last transaction will rollback.