Minimally logged and the recovery model
Yesterday, while attending a conference call related to a production issue at a client site, we had to emphasize to the client DBA one of the concepts related to minimally logged operation. It is well documented, however people tend to miss this information.
In SQL Server, there are several minimally logged operations which essentially means that only enough information is logged to be able to recover the transaction and point in time recovery is not supported for those minimal logged operations. Such operations are typically used for bulk data processing. Key point to remember is that if you are running under
…click on the title to read the full article…
Leave a Reply