EngageOne™

 View Only
  • 1.  New video - more than one way to create an EngageOne Designer repository backup

    Posted 09-03-2019 06:07
    Edited by Karen Piggott 09-03-2019 10:44
    Did you know there is more than one way to create an EngageOne Designer repository backup? 

    This #Video explains three different ways to create a full repository backup using the Repository Configuration Tool or SQL Management Studio.




    ------------------------------
    Karen Piggott
    CES Support
    Pitney Bowes Software Ltd
    HENLEY-ON-THAMES
    ------------------------------


  • 2.  RE: New video - more than one way to create an EngageOne Designer repository backup

    Posted 12-09-2020 15:03
    Hello Karen,

    unfortunately it seems, the video is no longer available. I'd be interested in how to automate full repository backups from the SQL Server Management Studio.

    Do you have an updated link to the video or documentation you could share?

    Thank you.​

    ------------------------------
    Daniel Friedrich
    United Health Care
    Duncan SC
    ------------------------------



  • 3.  RE: New video - more than one way to create an EngageOne Designer repository backup

    Posted 12-10-2020 11:30
    Hello Daniel

    Major element in this is the stored procedure spBR_FullBackup.
    If you have Repository Config Tool installed, and you have SQL Agent running, then you can schedule this stored procedure to execute the full backup. You can create an SQL Agent job that executes the procedure at certain times.
    Without the Repository config tool it might be more complex, as you might not have the necessary dll files at the system. In that case you need to create a script that creates a SQL backup of the database and also zippes the file store.

    ------------------------------
    Adrie vlutters
    Dialog Solutions Nederland BV
    Bunnik
    ------------------------------



  • 4.  RE: New video - more than one way to create an EngageOne Designer repository backup

    Posted 12-10-2020 11:37
    Hello Adrie,

    thank you very much for your response, appreciate it. We have a dedicated SQL server with the RCT installed on it, so, from the perspective, we should be good.

    Do you have an example of a SQL Agent that I could use as direction to set it up on my SQL server?​

    ------------------------------
    Daniel Friedrich
    United Health Care
    Duncan SC
    ------------------------------



  • 5.  RE: New video - more than one way to create an EngageOne Designer repository backup

    Posted 12-10-2020 11:46
    SQL Agent is a component of SQL server, usually as a separate service. If you enable the service, you will see it in the Management Studio. If you expand SQL Agent, you see a folder to create jobs.
    You can enable SQL Agent through the SQL Server Configuration manager.

    ------------------------------
    Adrie vlutters
    Dialog Solutions Nederland BV
    Bunnik
    ------------------------------