I run a bad query on my production server and I need to perform a restore of my database.
I had a full backup (20160828) and a diff backup (29,30,31 and 01/09) and I had transaction log backup.
Is it necessary to restore all the diff backups or only the last one?
Is it true that all restore operation I have to do must be in non recovery (the full, all the diff and all the transactionlog) except the last transaction log backup which must be restore with recovery?
Thanks in advance