Minimal Logging in SQL Server
Minimal logging involves logging only the information that is required to recover a transaction without supporting point-in-time recovery.Minimal logging is more efficient than full logging, and it reduces the possibility of bulk operations filling up transaction log. .To make high-volume data loading faster, SQL Server supports minimal logging. However, with minimal logging you cannot perform a point in time recovery for bulk operations.
0 comments:
Post a Comment