Postby torrie » Mon Sep 19, 2011 9:20 am
Sorry, I thought you were refering to the SQL extract.
You should be able to either use a windows batch script or a Jade application to automate a backup of the primary database to be put into the directory that you need the secondary. If the secondary INI file is configured correctly with the secondary relational role, then the system then starts up as a secondary. Unfortunately you still need to manually select the RPS mapping when it starts up. This would create a Full Extent secondary database. I don't know how to create a working set or mapped extent secondary.
If you are after a full extent, have you tried doing a restore from command line. Jdbutilb has a restore command which allow you to set the role. I don't know if this would keep the RPS mapping.
The JadeRPSManager section in the INI file stores the mapping name, but it sounds like this is only used by running the RPS Admin application.