Post reply

Running out of room on large insert operation

  • June 26, 2009 at 5:41 am

    #97827

    We are doing a one - time insert into a database and the log is growing to 15GB using ALL of the free space on the drive and blowing up.

    The insert is being done with a third party ETL tool - reading our datamart (15 million rows) and then doing inserts on one column in select rows our sql server DB. For each insert into the sql server DB, there is a trigger that writes to another table.

    Will simple recovery mode help me here?? Bulk-logged??

    any suggestions?

  • June 26, 2009 at 6:01 am

    #1015939

    Please see whether this link helps

    http://msdn.microsoft.com/en-us/library/ms190422.aspx

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 26, 2009 at 6:54 am

    #1015982

    Thanks. I read that before. I was looking for some pratical experience advice.. : )

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply