Home Forums SQL Server 2005 T-SQL (SS2K5) delete records in sql without entry in transaction log RE: delete records in sql without entry in transaction log

  • Hello,

    I have the same problem, I need to delete thousands and thousands of records, I dont want to truncate the table...

    the problem is that the log reach the 100GB and that slow down the DB

    how I can delete without logging and no truncate the table? any option?

    thanks in advanced,