Database Reference
In-Depth Information
The following screenshot was taken after the update statement was run. As you can
see, there are still no log flushes. This means that the previous transaction has not yet
been hardened to the transaction log. Thus, there is a chance that data loss might occur:
In order to ensure that the transaction and its data changes are hardened to the log
and thus durable, we need to run sp_flush_Log :
Use DB1
Go
EXEC SP_FLUSH_LOG
 
Search WWH ::




Custom Search