Home Forums SQL Server 7,2000 Backups How to automate a backup on prod and a restore on test? RE: How to automate a backup on prod and a restore on test?

  • I'd keep things the way they are. Then use VBScript (FileSystemObject) or Powershell to find the latest backup (not hard to do, loop files, find last one) and copy that to the test machine with a set name (LatestProdBackup.bak).

    Set a restore script to restore this.

    Use separate names on production, same name on test, some tweaking to do in the restore, remove users, sync logins, etc., but not that hard.