Versions Compared

Key

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

...

Back up the Repository Database

Use a tool such as IDERA SQLsafe SQL Safe to perform a full backup of the Repository database. If you changed the default recovery model to full, make sure your backup includes all transaction logs.

...

After you identify the appropriate backup frequency for your monitoring needs, use a tool such as IDERA SQLsafe SQL Safe to schedule routine backups of the Repository database. If you changed the default recovery model to full, make sure your backup includes all transaction logs.

...

  • To minimize data loss, plan to back up the Repository database on the temporary Repository computer immediately before reinstating the original computer.
  • Use the procedures in this Technical Solution to reinstate the Repository on the original computer and configure the Management Service.
  • To verify all components were reinstated correctly, test your implementation.
  • Uninstall the components you previously implemented on the temporary computer.

Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >


...