Page History
...
- Back up the SQL Secure repository database on the original server.
- Open the SQL Server Agent manager Manager on the repository server and find the SQLsecure Collector Job and the SQLsecure Groom Job.
- Create a SQL script for each job using the native tools.
...
- Restore the SQLsecure repository.
- Execute the collected SQL scripts to re-create the jobs.
Each collection job contains a command-line operation similar to the following:
Code Block C:\Program Files\Idera\SQLsecure\Bin\Idera.SQLsecure.Collector.exe" -TargetInstance "TARGETSERVER" -Repository "SERVER"
"Note Update the
"SERVER value to match the instance name of the new repository. Perform a Full Install of SQL Secure from the installation kit.
In the installation wizard, select the option to use an existing repository.
E-mail IDERA with the new SQL Server instance name that hosts the SQLsecure repository database. Then you will receive a new permanent key for the new SQLsecure installation.
...