November 3, 2014

What is a minimal logged in SQL

1.Minimal information it writes in the log file, when databse in bulk model.

2.If transaction is minimally logged only enough information is logged in transaction log to rollback the transaction no information is logged to roll it forward. This is why you loose point in time recovery if operation is minimally logged.