Automatic restore of the most recent file, is it possible?

Good morning, I want to create a restore job, I already tried the Backups and Restores and everything is Ok, but I need to know if this can be done, SQLBackupAndFTP takes daily backups, therefore the name of the BK file is different every day I want to do an automatic Restore that looks in the specific folder for “the most recent file” and restores it, is that possible?

Hello Enrrique_Vertiz,

To resolve the issue, please create a restore job, set a schedule for it, and select the option to restore the latest backup available.

For further information regarding how to create a restore job, please refer to the details provided at the following link: How to Restore SQL Server Backups | SQLBackupAndFTP's blog

If you have any other questions, please let us know.

Thank you!

Gracias por la explicacion !!!

Hello Enrrique_Vertiz,

No problem, please feel free to contact us on any issues or concerns.