Slå logning fra?

Det gør du ikke !

SQLServer virker ikke uden transaktions log.

Men du kan sætte recovery mode til simpel, så trunkererer den transaktions
log automatisk ved checkpoint (hver X. minut).

Ok, p.t. står den på "full" og nu har du forklaret mig "simpel", men hvad er "bulk log"?

Fra BOL:

Bulk-Logged Recovery
The Bulk-Logged Recovery model provides protection against media failure combined with the best performance and minimal log space usage for certain large-scale or bulk copy operations. 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).
In a Bulk-Logged Recovery model, the data loss exposure for these bulk copy operations is greater than in the Full Recovery model. While the bulk copy operations are fully logged under the Full Recovery model, they are minimally logged and cannot be controlled on an operation-by-operation basis under the Bulk-Logged Recovery model. Under the Bulk-Logged Recovery model, a damaged data file can result in having to redo work manually.

In addition, the Bulk-Logged Recovery model only allows the database to be recovered to the end of a transaction log backup when the log backup contains bulk changes. Point-in-time recovery is not supported.

Takker - tryk svar :-)

.

Hvor definerer jeg det punkt, hvor den skal trunkererer loggen?

med simple recovery model ?

det sker ved checkoint !

checkpoint