I need to check some old data. I need to check data from last night compared to data today.
I am going to use SQL Data Compare to do this but I need to setup a fresh database to restore the backup to so I can compare it against the existing database.
My question is if I have a full backup from 4-5 days ago, and a .dif for each day after that up until today, do I need ALL the .difs up to the point I want to restore or will the .dif from that day be sufficient? I assume I will need the most recent .bak as a basis for the new DB?