I’m using Restore-DBADatabase in DBATools to restore a daily database. Here’s the scenario. Vendor delivers a full backup of the database on Sundays and I download to D:\Bacups and restore it to our local database overwriting with:
Restore-DBADatabase -SQLInstance $Instance -Path D:\Backups -WithReplace
The rest of the week the vendor delivers differential files. So, for example, when I download Mondays differential to D:\Backups the full and the new diff are in the folder. Do I need to use the -WithReplace option, or is Restore-DBADatabase smart enough to figure out to just restore the differential file since the full backup was restored the day before? So, can I just do:
Restore-DBADatabase -SQLInstance $Instance -Path D:\Backups
Or do I need to remove the full backup file from the folder before restoring the differential so it doesn’t restore the whole database again?
I’m not really a DBA, so coming at this from powershell and DBATools.