xp_ss_restorelast needs to restore a stripped backup files or DIFF backup included.

by Mar 27, 2019

I found xp_ss_restorelast  is a very useful stored procedure to use, IF it supports a tripped backup files or DIFF backup without restore policy.

We have a complicated environment and need to “masking”  sensitive data before making a backup in some cases. For this we have our own SQL Agent job with a customized script.

XP_SS_restorelast actually is working well without a restore policy, BUT only with a single SAFE backup file.

I don’t understand why it does not support a stripped backup files?

Make matters worse, there is no documentation about this, so I had a hard time figuring out why it doesn’t work.

Anywyay, i hope it also supports DIFF backup.