We had a SQL Server crash and most of the data is unobtainable. I have found some old full backups and some differential backups in different servers.
Is there a way to tell which differential belongs to which full backup?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
From your description, you have a set of files some of which are full backups and some of which are differentials. If it were me, I'd use the various backup metadata interrogation commands inside the dbatools powershell module. Something like:
$bh = Get-DbaBackupInformation -SqlInstance yourRestoreServer -Path directoryForYourBackups; $bh | Restore-DbaDatabase -SqlInstance yourRestoreServer -OutputScriptOnly;
That first command will go through and do a
restore headeronly on all of the files and the second should select the most recent one(s) to do a restore on (which includes matching differential backups to full if that's an option).
If you don't already have the dbatools module installed, check out the installation instructions.