PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Enable the Microsoft application agent after migration to a different Microsoft SQL Server host

You can migrate to a different Microsoft SQL Server host and connect it with PowerProtect Data Manager by reusing the IP address and hostname of the former host.

1. Delete the original Microsoft SQL Server host by deleting the asset source according to Delete an asset source. This procedure unregisters the host from PowerProtect Data Manager and removes the host assets after all the asset copies have expired.

   The assets and asset source of the original host are still in the "Deleted" state, unless the asset copies have expired and garbage collection has run.

   NOTE:If you unregister and reregister the Microsoft application agent instead of completing this deletion step, then duplicated asset names might appear in the PowerProtect Data Manager UI.
2. Migrate the Microsoft SQL Server application from the original host to the new Microsoft SQL Server host. Ensure that the new host has the same IP address and FQDN as the original host.
3. Run the Microsoft application agent installation on the new Microsoft SQL Server host and select the Change option to register the new host with the same PowerProtect Data Manager server as the original host.
4. Run a manual discovery, backup, and restore on the new Microsoft SQL Server host. Ensure that the operations are successful.