thanks khairey. could you also explain 'resetting the transaction log' part. Does it resets after full backup or periodic transaction log backups. So after I take my full backup, it truncates the transaction log? whats this truncating? some scenarious would be helpful