Home Forums SQL Server 2005 Administering Deleting records from a huge table RE: Deleting records from a huge table

  • February 8, 2010 at 4:18 pm

    #1115860

    1. Assuming your back up is FULL RECOVERY. Perform a complete backup

    2. Use Set ROWCOUNT to a resonable size (Start low, watch your log file size, and the time to process the batch, display the estimated execution plan and review it before starting your first batch)

    3. At the end of each batch of deleting, backup your log file

    4. Be sure to save the Full back up and all log backup, you do not want to break the chain in case you need to perform a restore.

    And test, test, and test again before using on your Production DB.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]