Posted on Leave a comment

Bulk-Logged Recovery

Bulk-Logged Recovery

These operations are minimally logged:
  • SELECT INTO.
  • Bulk load operations (bcp and BULK INSERT).
  • CREATE INDEX (including indexed views).
  • text and image operations (WRITETEXT and UPDATETEXT).
Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.