Delete rows, without transcation logging

Last Post 22 May 2008 12:04 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mikeman
New Member
New Member

--
20 May 2008 07:45 AM
How can I delete data in a table by date field and prevent the process from writing to the transaction log? The log is getting to big for the HD space, so I need to be able to do this. Thanks
SQLUSA
New Member
New Member

--
22 May 2008 12:04 AM
quote:

Originally posted by: Pro Pete
Deleting rows in smaller chunks will only help with Log size issue if database in Simple recovery model or Log Backup performed between chunks.


Even if you are in FULL recovery, during maintenance period you can flip over to Simple, do your deletes, and flip back to FULL. Obviously you can't do mirroring or log-shipping during this period.

Alternative to deleting: Add IsActive flag to table(s). Delete periodically (like year-end) based on flag. Actually this solution will speed up db operations because delete can be real slow.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/

You are not authorized to post a reply.

Acceptable Use Policy