<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article EPM - How to migrate EPM DB's to different SQL instance. in Endpoint Privilege Manager (EPM) Articles</title>
    <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/epm-how-to-migrate-epm-db-s-to-different-sql-instance/ta-p/1430049</link>
    <description>How can I migrate EPM DB's to a different SQL instance? (for the purpose of SQL upgrade, SQL machine change, or otherwise)

&lt;H3&gt;Steps&lt;/H3&gt;
Use the following steps-&lt;BR /&gt;&lt;B&gt;1.&lt;/B&gt; Backup all DB's&amp;nbsp;&lt;BR /&gt;- This can be done using the built in Backup Tool in the Administration page&amp;nbsp;&lt;BR /&gt;Administration &amp;gt; Configuration &amp;gt; Backup Settings &amp;gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;- Or manually for all DB"s that begin with VF&amp;nbsp;&lt;BR /&gt;In 5.+ that means - VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;2.&lt;/B&gt; Restore in new location/SQL instance and &lt;B&gt;run revive script&lt;/B&gt;&lt;BR /&gt;Please refer to &lt;A href="https://live.paloaltonetworks.com/articles/Knowledge_Article/How-to-restore-EPM-database-from-backup" target="_blank"&gt;How to restore EPM database from backup&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;3.&lt;/B&gt; Afterwards perform an Uninstall and Reinstall of the Manager from the IIS Machine.&amp;nbsp;&lt;BR /&gt;During the reinstall, point the installation at the restored DB's in the "new" location. (Note it is critical that the IIS FQDN is the same as was used before)&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;When the "reinstall" or "upgrade install" happens with the installer, it will validate all user access and permissions, as well as update the connection points needed in the DB.&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;But if you are looking to validate afterwards, the connection strings can all be seen in the following 2 tables-&amp;nbsp;&lt;BR /&gt;a. Expand VFMNGDB5 &amp;gt; find table called DBO.tblSetConfigs&amp;nbsp;&lt;BR /&gt;b. Expand VFMNGDB5 &amp;gt; find table called vfdsp.tblManagerConnectionPoints&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Note - We do not advise making any manual changes to these tables without consulting CyberArk.&amp;nbsp;&lt;BR /&gt;Note2 - When you reinstall *it is crucial that the FQDN of the server stay the same.*&amp;nbsp;&lt;BR /&gt;Note 3 - If upgrading SQL or changing the Reporting Services instance as well - make sure that the User Accounts for MS SQL Database and Reporting Services are given the "sysadmin" Server Role. This is only temporary and once the installation is completed, the user account will only need “db_owner” and “db_backupoperator” roles. The Reporting Services Account also requires local Administrator privileges.

&lt;DIV&gt;
&lt;DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;How can I migrate EPM DB's to a different SQL instance? (for the purpose of SQL upgrade, SQL machine change, or otherwise)&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Use the following steps-&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;1. Backup all DB's&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- This can be done using the built in Backup Tool in the vfadmin/Administration page&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Administration &amp;gt; Configuration &amp;gt; Backup Settings &amp;gt;&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- Or manually for all DB"s that begin with VF&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;In 5.+ that means - VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;2. Restore in new location/SQL instance and run revive script&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Please refer to *&lt;A href="https://cyberark.my.salesforce.com/50150000000pYuA?srPos=0&amp;amp;srKp=501" target="_blank"&gt;solution 3739&lt;/A&gt;*&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;3. Afterwards perform an Uninstall and Reinstall of the Manager from the IIS Machine.&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;During the reinstall, point the installation at the restored DB's in the "new" location. (Note it is critical that the IIS FQDN is the same as was used before)&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;When the "reinstall" or "upgrade install" happens with the installer, it will validate all user access and permissions, as well as update the connection points needed in the DB.&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;But if you are looking to validate afterwards, the connection strings can all be seen in the following 2 tables-&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;a. Expand VFMNGDB5 &amp;gt; find table called DBO.tblSetConfigs&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;b. Expand VFMNGDB5 &amp;gt; find table called vfdsp.tblManagerConnectionPoints&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Note - We do not advise making any manual changes to these tables without consulting CyberArk.&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Note2 - When you reinstall *it is crucial that the FQDN of the server stay the same.*&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Note 3 - If upgrading SQL or changing the Reporting Services instance as well - make sure that the User Accounts for MS SQL Database and Reporting Services are given the "sysadmin" Server Role. This is only temporary and once the installation is completed, the user account will only need “db_owner” and “db_backupoperator” roles. The Reporting Services Account also requires local Administrator privileges.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;</description>
    <pubDate>Tue, 04 Aug 2020 16:58:35 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2020-08-04T16:58:35Z</dc:date>
    <item>
      <title>EPM - How to migrate EPM DB's to different SQL instance.</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/epm-how-to-migrate-epm-db-s-to-different-sql-instance/ta-p/1430049</link>
      <description>How can I migrate EPM DB's to a different SQL instance? (for the purpose of SQL upgrade, SQL machine change, or otherwise)

&lt;H3&gt;Steps&lt;/H3&gt;
Use the following steps-&lt;BR /&gt;&lt;B&gt;1.&lt;/B&gt; Backup all DB's&amp;nbsp;&lt;BR /&gt;- This can be done using the built in Backup Tool in the Administration page&amp;nbsp;&lt;BR /&gt;Administration &amp;gt; Configuration &amp;gt; Backup Settings &amp;gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;- Or manually for all DB"s that begin with VF&amp;nbsp;&lt;BR /&gt;In 5.+ that means - VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;2.&lt;/B&gt; Restore in new location/SQL instance and &lt;B&gt;run revive script&lt;/B&gt;&lt;BR /&gt;Please refer to &lt;A href="https://live.paloaltonetworks.com/articles/Knowledge_Article/How-to-restore-EPM-database-from-backup" target="_blank"&gt;How to restore EPM database from backup&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;3.&lt;/B&gt; Afterwards perform an Uninstall and Reinstall of the Manager from the IIS Machine.&amp;nbsp;&lt;BR /&gt;During the reinstall, point the installation at the restored DB's in the "new" location. (Note it is critical that the IIS FQDN is the same as was used before)&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;When the "reinstall" or "upgrade install" happens with the installer, it will validate all user access and permissions, as well as update the connection points needed in the DB.&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;But if you are looking to validate afterwards, the connection strings can all be seen in the following 2 tables-&amp;nbsp;&lt;BR /&gt;a. Expand VFMNGDB5 &amp;gt; find table called DBO.tblSetConfigs&amp;nbsp;&lt;BR /&gt;b. Expand VFMNGDB5 &amp;gt; find table called vfdsp.tblManagerConnectionPoints&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Note - We do not advise making any manual changes to these tables without consulting CyberArk.&amp;nbsp;&lt;BR /&gt;Note2 - When you reinstall *it is crucial that the FQDN of the server stay the same.*&amp;nbsp;&lt;BR /&gt;Note 3 - If upgrading SQL or changing the Reporting Services instance as well - make sure that the User Accounts for MS SQL Database and Reporting Services are given the "sysadmin" Server Role. This is only temporary and once the installation is completed, the user account will only need “db_owner” and “db_backupoperator” roles. The Reporting Services Account also requires local Administrator privileges.

&lt;DIV&gt;
&lt;DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;How can I migrate EPM DB's to a different SQL instance? (for the purpose of SQL upgrade, SQL machine change, or otherwise)&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Use the following steps-&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;1. Backup all DB's&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- This can be done using the built in Backup Tool in the vfadmin/Administration page&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Administration &amp;gt; Configuration &amp;gt; Backup Settings &amp;gt;&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- Or manually for all DB"s that begin with VF&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;In 5.+ that means - VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;2. Restore in new location/SQL instance and run revive script&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Please refer to *&lt;A href="https://cyberark.my.salesforce.com/50150000000pYuA?srPos=0&amp;amp;srKp=501" target="_blank"&gt;solution 3739&lt;/A&gt;*&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;3. Afterwards perform an Uninstall and Reinstall of the Manager from the IIS Machine.&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;During the reinstall, point the installation at the restored DB's in the "new" location. (Note it is critical that the IIS FQDN is the same as was used before)&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;When the "reinstall" or "upgrade install" happens with the installer, it will validate all user access and permissions, as well as update the connection points needed in the DB.&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;But if you are looking to validate afterwards, the connection strings can all be seen in the following 2 tables-&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;a. Expand VFMNGDB5 &amp;gt; find table called DBO.tblSetConfigs&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;b. Expand VFMNGDB5 &amp;gt; find table called vfdsp.tblManagerConnectionPoints&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Note - We do not advise making any manual changes to these tables without consulting CyberArk.&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Note2 - When you reinstall *it is crucial that the FQDN of the server stay the same.*&amp;nbsp;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Note 3 - If upgrading SQL or changing the Reporting Services instance as well - make sure that the User Accounts for MS SQL Database and Reporting Services are given the "sysadmin" Server Role. This is only temporary and once the installation is completed, the user account will only need “db_owner” and “db_backupoperator” roles. The Reporting Services Account also requires local Administrator privileges.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;</description>
      <pubDate>Tue, 04 Aug 2020 16:58:35 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/epm-how-to-migrate-epm-db-s-to-different-sql-instance/ta-p/1430049</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-08-04T16:58:35Z</dc:date>
    </item>
  </channel>
</rss>

