As we mentioned previously, an incomplete recovery occurs when the backup is restored and some, but not all, of the changes are applied. However, we need to set a condition, such as a time, in order to establish the point at which recovery will be stopped. In this section, we'll perform an incomplete recovery using one of these conditions as an example.
Incomplete recovery can be performed using three different methods. The method chosen depends on the granularity of the data that needs to be restored. Each method has certain advantages and disadvantages.