I am using SqlBackUpAndFtp to backup the db to google drive
here is what it looks like on the other server
The backup server is one that isn't always on, but it is set to get the latest DB via google drive so i have a backup of it
I would now like to restore the DB to the backup server
But I would like this done automatically
As you can see, 2 are complete backups, and the rest are logs
I would be fine with just restoring the full backups.
Is this possible? to automatically look at this DIR and restore the latest DB?
Is there a program that will do this, or does anyone have a script or something?