I am reading about different types of backup policy in sql server. I am not clear with backup policy for Full + Differential + Transactional backiup
My main attention is towards what all files would be required at the time of restoration. As per the diagram given on SQL Authority, it seems like I need all the files i.e.
last full backup file 1 + log file 1.1 + log file 1.2 + differential 1.1 + log file 1.4 + log file 1.5 + Differential 1.2 + ...all log files..
or did i interpret it wrong and I would need
last full backup file + differential 2 + log file 2.1 + log file 2.2....
What is contained in differential backup, is it just mdf + ndf backup or ldf + mdf + ndf backup since last full backup was taken?