Versions Compared

Old Version 2

changes.mady.by.user Alejandra Barrientos

Saved on

compared with

New Version 3

changes.mady.by.user Alejandra Barrientos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Back up the SQL Secure repository database on the original server.
  2. Open the SQL Server Agent manager on the repository server , and find the SQLsecure Collector Job and the SQLsecure Groom Job.
  3. Create a SQL script for each job using the native tools.

...

  1. Restore the SQLsecure repository.
  2. Execute the collected SQL scripts to re-create the jobs.

  3. 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"

    Update the "SERVER" value to match the instance name of the new repository.

  4. Perform a Full Install of SQL Secure from the installation kit.

  5. In the installation wizard, select the option to use an existing repository.

  6. E-mail licensing@idera.comIDERA 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.

...