sp_DatabaseRestore

sp_DatabaseRestore

I'm just curious if others use sp_DatabaseRestore from Brent Ozar's First Responder's Kit. If so, are you having any issues restoring differentials?

Here's some context. I use Ola's scripts for our full, diff, and t-log backups. It has served us well. I wanted an easy way to restore just the full, the full + diff, or full + t-log (point in time) if I needed to. I've found that I can successfully do the first and third (just the full and full + t-log). However, if I simply try to restore a full and a differential, I only ever end up with the full. Now I haven't dug into the code a ton. I actually plan to, but before I spend hours trying to figure out what's happening, I thought I'd at least check with all of you to see if you notice anything dumb that I'm just missing. Here's an example of a command I'd use to attempt to restore the full and diff.

I should also note that the debug does not print commands that indicate that a diff restore is happening, so it seems to not even get to the correct block of code. Before I go digging, does anyone see anything inherently wrong with my stored procedure call?

I'm not exactly sure what you mean. I use Ola Hallengren's backup scripts. What exactly are you looking for?

I should also note that I was able to restore the full and the diff using the RESTORE DATABASE command, so I know there's not an issue with the backup files themselves (at least, I think that proves that there isn't...)

Thank you for the suggestion. Even though I don't think specifying a log path should be a requirement for diffs, I gave it a try. Unfortunately, it still didn't restore the diff. Now, to be fair, I didn't actually put any log files in the directory--I only specified a path in the call. Also, as you can see, for simplicity, all of my paths are the same. I'm not sure if either of these two things (not putting actual log files in the directory and using the same directory for everything) had anything to do with the diff not getting picked up, but I'll keep digging...