Skip to main content
Database Administrators

Return to Question

Post Reopened by John K. N., Hannah Vernon♦, Paul White♦
edited tags
Link
Hannah Vernon ♦
Hannah Vernon ♦
  • 70.5k
  • 22
  • 177
  • 321
added 158 characters in body
Source Link
J. D.
J. D.
  • 21
  • 1
  • 3

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. Could you please tell how to do that so that

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 picks usto pick up those dynamic? Thanks files from the backup location. Please advise.

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. Could you please tell how to do that so that the job picks us dynamic? Thanks.

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.

Post Closed as "Needs details or clarity" by John K. N., McNets, Michael Green, Scott Hodgin - Retired, Colin 't Hart
Source Link
J. D.
J. D.
  • 21
  • 1
  • 3

Restoring from a backup having dynamic file names

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. Could you please tell how to do that so that the job picks us dynamic? Thanks.