I want to restore a backup from a set of multiple files. The file names are generated dynamically. I have to restore the UAT with that backup. I need to schedule a job for this restore.

This is SQL Server 2012. Our backup script is split into 20 files, and everytime they are generated with timestamp. Now while restoring, we need the restore job to pick up those dynamic files from the backup location. Please advise.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.