You must revise configuration settings if you move the vRealize Automation IaaS SQL database to a different host name.

On the same host name, you can restore the SQL database from a backup with no further steps required. If you restore to a different host name, you need to edit configuration files to make additional changes.

See VMware Knowledge Base article 2074607 for the changes required when moving the SQL database to a different host name.