Is WITH NOLOGGING is there in SQL server .?

• karthikaug18

  Say Hey Kid

  Points: 662

  More actions

  February 1, 2012 at 4:38 am

  #263885

  Is WITH NOLOGGING is there in SQL server .?

  Can i use WITH NOLOGGING option for UPDATE, INSERT, DELETE in T-SQL.?

• BrainDonor

  SSCoach

  Points: 19262

  More actions

  February 1, 2012 at 4:45 am

  #1441125

  The closest equivalent to that Oracle option is probably Bulk Logged Recovery - see http://msdn.microsoft.com/en-us/library/ms189275.aspx and http://msdn.microsoft.com/en-us/library/ms191244.aspx.

  Steve Hall
  Linkedin
  Blog Site

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 1, 2012 at 6:04 am

  #1441168

  No. All operations are logged always.

  In simple and bulk-logged recovery models some operations can be minimally logged, but it's only a small subset of operations.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• johnitech.itech

  Hall of Fame

  Points: 3252

  More actions

  February 6, 2012 at 6:44 am

  #1443082

  very useful article same point ,It cannot do that but use simple mode to derease backup

  http://stackoverflow.com/questions/571750/make-sql-server-faster-at-manipulating-data-turn-off-transaction-logging