hello, is there a best practice script for finding the latest full backup file for a database? i'm trying to automate the restoration of the latest full backup file to a QA database that is on the same server as the development database. Dev db gets backed up ever night. i want to restore that backup to the QA database.
Thanks in advance,