I am trying to dynamically restore a database with multiple BAK files (about 9+) that are located in one folder on a daily basis.
So, updating one database with multiple BAK files..
What should be the best approach?
How should I write a cursor , stored procedure or powershell script?
Basically, all BAK files would be located in one folder, and the task is grab each file and restore to one database.
I am thinking SQL Server Agent will do the job (like running Powershell or run a stored procedure), but I don't know how to express the logic.
Any guidance would be appreciated.
Thanks



