I know this post is a few months old, but I also had this same issue. I ended up splitting up the Full and Differential Restore which worked for me.
EXEC DBA_Utils.dbo.sp_DatabaseRestore
@Database = 'production',
@RestoreDatabaseName = 'test',
@BackupPathFull = 'E:\temporary\FULL\',
@RunRecovery = 0;
EXEC DBA_Utils.dbo.sp_DatabaseRestore
@Database = 'production',
@RestoreDatabaseName = 'test',
@BackupPathDiff = 'E:\temporary\DIFF\',
@RestoreDiff = 1,
@RunRecovery = 1;
Hi Megan,
Thank you for posting this. It makes perfect sense to just split it into two steps--full with norecovery then the diff. I had shifted to dbatools to build my restore process, but if I need to go back to sp_DatabaseRestore, I'll know how to do it. Again, thank you.
Mike
Mike Scalise, PMP
https://www.michaelscalise.com