February 1, 2012 at 4:38 am
Is WITH NOLOGGING is there in SQL server .?
Can i use WITH NOLOGGING option for UPDATE, INSERT, DELETE in T-SQL.?
February 1, 2012 at 4:45 am
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.
February 1, 2012 at 6:04 am
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
February 6, 2012 at 6:44 am
very useful article same point ,It cannot do that but use simple mode to derease backup
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply