Sunday, November 2, 2014

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).

No comments:

Post a Comment