• You existing backup process should already be automated.

    Assuming this is the case: determine where those backups are going; determine whether the test server has access to the backup files; determine the frequency and naming convention of the backup files.

    Then you can create a SQL Agent job which will contain a RESTORE command referencing the backup file you want to restore to the test server.