• So what you want is to restore the latest backup? regardless if the backup is 1 or 2 days ago as long as it is the current one? are you restoring...

    only 1 backup?

    1 diff and 1 full?

    1 full?

    1. you can retain (in the cmdshell table) the max date from your script

    2. you can look per filename (which is your format) or per system date (the first 20 chars of the result in cmdshell table)

    "-=Still Learning=-"

    Lester Policarpio