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?

  • You should not need to disable the log backup.

    I think for #2, he means a RESTORE command as the query. It's not a query per se, but a batch command.