Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    16

    Unanswered: Large Delete & tran log

    I have a table that has 110 million records, I will be deleting over 60 million records, but I dont have enough space to hold all the deletes on the trans log file. Is there a way to delete 1 million record then free the trans action then run another delete in one script.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Set up simple model for your database and fire your deletes: 1000000 or less records - transaction log will be freed after every delete.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •