Forum Discussion

carlos_espinoza's avatar
11 years ago
Solved

How I can schedule a restore and repeat it weekly?

Hi,


Like a backup job this can repeat weekly, daily, monthly, etc. In this case we search the option to schedule a restore job and repeat it. The idea is restore one DB, weekly on sunday. How I can do this? I can't find it in the wizard of restore, you can only restore one time on a day and hour.

 

Regards,

 

Carlos Espinoza

  • Hi,

     

    This cannot be done. Never been an automated part of BE either in any addition. I suspect there have been some Ideas around this, so check out that section.

    Your only other option is to create a Restore job, and place it on hold before running it manually when you need to.

    THanks!

  • Automated restores CANNOT be done because you need to tell a restore what backup set to use. How do you schedule a restore for the next week when the backup set has not been created?
  • Hi,

     

    This cannot be done. Never been an automated part of BE either in any addition. I suspect there have been some Ideas around this, so check out that section.

    Your only other option is to create a Restore job, and place it on hold before running it manually when you need to.

    THanks!

  • Thank you CraigV,

    The option to run manually, isn't the idea, we planning to run this on sunday as I said.

    Any idea to run this?

  • Automated restores CANNOT be done because you need to tell a restore what backup set to use. How do you schedule a restore for the next week when the backup set has not been created?
  • ...as I mentioned above, automated restores in BE have never been available, although plenty of people have asked for this.

    You can add it in as an Idea, but I doubt that it will be done. The main issue behind this is simply that you could restore data over production data when you don't want to do this.

    Thanks!

  • That's not problem I will use the same old backup to restore it. It's necessary that the DB starts as original.

  • Thank you to all guys that answered this forum.

    I see a solution using the BEMCMD, I will create a restore script and put it in a bat file. Then this bat file I will run using the Task Scheduler of Windows with the frecuency that I need.

     

    • Amarreddyv's avatar
      Amarreddyv
      Level 1

      Hi Carlos,

      Even I am also looking for the same automated restore, can you please help me to configure the job and how the script is configured with BEMCMD,

      • RogRubin's avatar
        RogRubin
        Moderator

        The problem is as explained by CraigV and pkh, that the data you want to do the test restore from has not been backed up yet and therefore you cannot configure/specify the required value of what data to restore when it does not exist yet.

        General info about BEMCLI you can get by:
        - On the computer on which Backup Exec is installed, on the taskbar, click Start > All Programs > Veritas Backup Exec > Backup Exec Management Command Line Interface.
        or
        On the computer on which Backup Exec is installed, launch PowerShell, and then type Import-Module BEMCLI.   

        Once you on the command interface type:  Show-BEHelp    and you will get a list of all commands possible.

  • BE 2012 does not use BEMCMD. It uses BEMCLI instead