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?

  • September 3, 2009 at 12:12 pm

    #1048993

    Sarabpreet,

    Thanks for your response. I have two questions; what do you mean when you say:

    1. Disable the log backup on prod.

    I am taking a nightly full database backup and log file backup even though we are not using the log backups to retore. So, basically, I have a full database backup.

    Also, what do you mean when you say to restore the database using a query.

    6. Restore the DB using a predefined query since the name of the backup file is still pre-defined.

    I normally use a Restore Command.

    Thanks, Kevin