<?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 How to restore EPM database from backup in Endpoint Privilege Manager (EPM) Articles</title>
    <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/how-to-restore-epm-database-from-backup/ta-p/1429996</link>
    <description>Q: How do I restore EPM databases from backup?&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;

&lt;H3&gt;Steps&lt;/H3&gt;
A:&lt;BR /&gt;&lt;BR /&gt;1. Open IIS Manager and stop your server.&lt;BR /&gt;&lt;BR /&gt;2. login to Microsoft SQL Server Management Studio&lt;BR /&gt;&lt;BR /&gt;3. Right click VFMNGDB5 and select Properties, in the next window on the left pane select Options, under State set Restrict Access to SINGLE_USER (This option only needs to be done for your VFMNGDB5&amp;nbsp;database)&lt;BR /&gt;&lt;BR /&gt;4. Select your database backup files&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;- begin with restoring "VFSTAGEDB5", then "VFMNGDB5", then "VFNESTDB5", then "VFSTATDB5", then "VFEVENTSDB5"&lt;BR /&gt;&lt;BR /&gt;5. Right click VFSTAGEDB5 -&amp;gt; Tasks -&amp;gt; Restore -&amp;gt; Database...&lt;BR /&gt;&lt;BR /&gt;6. Select the backup sets to restore&lt;BR /&gt;&lt;BR /&gt;7. Under Options &amp;gt; Select check-box to "Overwrite the existing database (WITH REPLACE)"&lt;BR /&gt;&lt;BR /&gt;8. The restore of the database should complete successful (&lt;B&gt;Repeat these steps for the other databases&lt;/B&gt;)&lt;BR /&gt;&lt;BR /&gt;9. Perform only &lt;B&gt;ONE &lt;/B&gt;of the following&lt;BR /&gt;&lt;BR /&gt;a.&amp;nbsp;&lt;B&gt;FOR&amp;nbsp; EPM v10.10+&lt;/B&gt; =&amp;nbsp;After restoring all of the databases, you need to authorize them in the system.&lt;BR /&gt;- Right click on VFMNGDB5 &amp;gt; New Query&lt;BR /&gt;- Write the command
&lt;PRE class="ckeditor_codeblock"&gt;
EXEC dbo.usp_VfScheduledJobReviveAfterRecovery&lt;/PRE&gt;
- Click on !Execute in the toolbar (or hit F5)&lt;BR /&gt;&lt;BR /&gt;b. &lt;B&gt;FOR EPM v5.5-10.9&lt;/B&gt; =&amp;nbsp;Manually !Execute&amp;nbsp;the following query against&amp;nbsp;all&amp;nbsp;EPM Databases (VFMNGDB5,&amp;nbsp;VFNESTDB5,&amp;nbsp;VFSTAGEDB5,&amp;nbsp;VFSTATDB5,&amp;nbsp;VFEVENTSDB5)

&lt;PRE class="ckeditor_codeblock"&gt;
DECLARE @DbName nvarchar(max), @Principal sysname&amp;nbsp;
SELECT @DbName = CONVERT(nvarchar(max), DB_NAME())&amp;nbsp;
SELECT @Principal = name&amp;nbsp;
FROM sys.server_principals&amp;nbsp;
WHERE (sid = 0x01)&amp;nbsp;
EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON')&amp;nbsp;
EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];')&lt;/PRE&gt;
&lt;P class="MsoNormal"&gt;&lt;B&gt;&lt;U&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Q:&lt;/FONT&gt;&lt;/U&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;How do I restore database from backup?&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B&gt;&lt;U&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;A:&lt;/FONT&gt;&lt;/U&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;1. Open IIS Manager and stop your server.&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;2. login to Microsoft SQL Server Management Studio&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;3. Right click &lt;B&gt;VFMNGDB &lt;/B&gt;and select &lt;B&gt;Properties&lt;/B&gt;, in the next window on the left pane select &lt;B&gt;Options&lt;/B&gt;, under &lt;B&gt;State&lt;/B&gt; set &lt;B&gt;Restrict Access&lt;/B&gt; to &lt;B&gt;SINGLE_USER &lt;/B&gt;(This option only needs to be done for your &lt;B&gt;VFMNGDB5&amp;nbsp;&lt;/B&gt;database)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;4. Right click &lt;B&gt;VFMNGDB -&lt;/B&gt;&amp;gt; &lt;B&gt;Tasks&lt;/B&gt; -&amp;gt; &lt;B&gt;Restore&lt;/B&gt; -&amp;gt; &lt;B&gt;Database...&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;5. Select your database backup files&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- begin with restoring "&lt;B&gt;VFSTAGEDB5"&lt;/B&gt;, then &lt;B&gt;"VFMNGDB5"&lt;/B&gt;, then &lt;B&gt;"VFNESTDB5"&lt;/B&gt;, then &lt;B&gt;"VFSTATDB5"&lt;/B&gt;, then &lt;B&gt;"VFEVENTSDB5"&lt;/B&gt;)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;6. Select the backup sets to restore&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;7. Under &lt;B&gt;Options&lt;/B&gt; &amp;gt; Select check-box to &lt;B&gt;"Overwrite the existing database (WITH REPLACE)"&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;8. The restore of the database should complete successful (&lt;B&gt;&lt;I&gt;Repeat these steps for the other databases&lt;/I&gt;&lt;/B&gt;)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;9. Perform only ONE of the following&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;9a.&amp;nbsp;FOR v10.10+ =&amp;nbsp;&lt;/B&gt;After restoring all of the databases, you need to authorize them in the system.&lt;BR /&gt;- Right click on VFMNGDB5 &amp;gt; New Query&lt;BR /&gt;- Write the command "EXEC dbo.usp_VfScheduledJobReviveAfterRecovery"&lt;BR /&gt;- Click on !Execute in the toolbar (or hit F5)&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;9b. FOR v5.5-10.9 =&amp;nbsp;&lt;/B&gt;&lt;/FONT&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Manually !Execute&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;the following query against&amp;nbsp;&lt;B&gt;all&amp;nbsp;&lt;/B&gt;EPM Databases (&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;B&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFMNGDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFNESTDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFSTAGEDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFSTATDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;VFEVENTSDB5&lt;/B&gt;)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="background-color: #ffffff;"&gt;&lt;SPAN style="background-color: #ffffff;"&gt;DECLARE @DbName nvarchar(max), @Principal sysname&amp;nbsp;&lt;BR /&gt;SELECT @DbName = CONVERT(nvarchar(max), DB_NAME())&amp;nbsp;&lt;BR /&gt;SELECT @Principal = name&amp;nbsp;&lt;BR /&gt;FROM sys.server_principals&amp;nbsp;&lt;BR /&gt;WHERE (sid = 0x01)&amp;nbsp;&lt;BR /&gt;EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON')&amp;nbsp;&lt;BR /&gt;EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];')&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 17 Aug 2020 10:11:34 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2020-08-17T10:11:34Z</dc:date>
    <item>
      <title>How to restore EPM database from backup</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/how-to-restore-epm-database-from-backup/ta-p/1429996</link>
      <description>Q: How do I restore EPM databases from backup?&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;

&lt;H3&gt;Steps&lt;/H3&gt;
A:&lt;BR /&gt;&lt;BR /&gt;1. Open IIS Manager and stop your server.&lt;BR /&gt;&lt;BR /&gt;2. login to Microsoft SQL Server Management Studio&lt;BR /&gt;&lt;BR /&gt;3. Right click VFMNGDB5 and select Properties, in the next window on the left pane select Options, under State set Restrict Access to SINGLE_USER (This option only needs to be done for your VFMNGDB5&amp;nbsp;database)&lt;BR /&gt;&lt;BR /&gt;4. Select your database backup files&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;- begin with restoring "VFSTAGEDB5", then "VFMNGDB5", then "VFNESTDB5", then "VFSTATDB5", then "VFEVENTSDB5"&lt;BR /&gt;&lt;BR /&gt;5. Right click VFSTAGEDB5 -&amp;gt; Tasks -&amp;gt; Restore -&amp;gt; Database...&lt;BR /&gt;&lt;BR /&gt;6. Select the backup sets to restore&lt;BR /&gt;&lt;BR /&gt;7. Under Options &amp;gt; Select check-box to "Overwrite the existing database (WITH REPLACE)"&lt;BR /&gt;&lt;BR /&gt;8. The restore of the database should complete successful (&lt;B&gt;Repeat these steps for the other databases&lt;/B&gt;)&lt;BR /&gt;&lt;BR /&gt;9. Perform only &lt;B&gt;ONE &lt;/B&gt;of the following&lt;BR /&gt;&lt;BR /&gt;a.&amp;nbsp;&lt;B&gt;FOR&amp;nbsp; EPM v10.10+&lt;/B&gt; =&amp;nbsp;After restoring all of the databases, you need to authorize them in the system.&lt;BR /&gt;- Right click on VFMNGDB5 &amp;gt; New Query&lt;BR /&gt;- Write the command
&lt;PRE class="ckeditor_codeblock"&gt;
EXEC dbo.usp_VfScheduledJobReviveAfterRecovery&lt;/PRE&gt;
- Click on !Execute in the toolbar (or hit F5)&lt;BR /&gt;&lt;BR /&gt;b. &lt;B&gt;FOR EPM v5.5-10.9&lt;/B&gt; =&amp;nbsp;Manually !Execute&amp;nbsp;the following query against&amp;nbsp;all&amp;nbsp;EPM Databases (VFMNGDB5,&amp;nbsp;VFNESTDB5,&amp;nbsp;VFSTAGEDB5,&amp;nbsp;VFSTATDB5,&amp;nbsp;VFEVENTSDB5)

&lt;PRE class="ckeditor_codeblock"&gt;
DECLARE @DbName nvarchar(max), @Principal sysname&amp;nbsp;
SELECT @DbName = CONVERT(nvarchar(max), DB_NAME())&amp;nbsp;
SELECT @Principal = name&amp;nbsp;
FROM sys.server_principals&amp;nbsp;
WHERE (sid = 0x01)&amp;nbsp;
EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON')&amp;nbsp;
EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];')&lt;/PRE&gt;
&lt;P class="MsoNormal"&gt;&lt;B&gt;&lt;U&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Q:&lt;/FONT&gt;&lt;/U&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;How do I restore database from backup?&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B&gt;&lt;U&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;A:&lt;/FONT&gt;&lt;/U&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;1. Open IIS Manager and stop your server.&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;2. login to Microsoft SQL Server Management Studio&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;3. Right click &lt;B&gt;VFMNGDB &lt;/B&gt;and select &lt;B&gt;Properties&lt;/B&gt;, in the next window on the left pane select &lt;B&gt;Options&lt;/B&gt;, under &lt;B&gt;State&lt;/B&gt; set &lt;B&gt;Restrict Access&lt;/B&gt; to &lt;B&gt;SINGLE_USER &lt;/B&gt;(This option only needs to be done for your &lt;B&gt;VFMNGDB5&amp;nbsp;&lt;/B&gt;database)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;4. Right click &lt;B&gt;VFMNGDB -&lt;/B&gt;&amp;gt; &lt;B&gt;Tasks&lt;/B&gt; -&amp;gt; &lt;B&gt;Restore&lt;/B&gt; -&amp;gt; &lt;B&gt;Database...&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;5. Select your database backup files&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- begin with restoring "&lt;B&gt;VFSTAGEDB5"&lt;/B&gt;, then &lt;B&gt;"VFMNGDB5"&lt;/B&gt;, then &lt;B&gt;"VFNESTDB5"&lt;/B&gt;, then &lt;B&gt;"VFSTATDB5"&lt;/B&gt;, then &lt;B&gt;"VFEVENTSDB5"&lt;/B&gt;)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;6. Select the backup sets to restore&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;7. Under &lt;B&gt;Options&lt;/B&gt; &amp;gt; Select check-box to &lt;B&gt;"Overwrite the existing database (WITH REPLACE)"&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;8. The restore of the database should complete successful (&lt;B&gt;&lt;I&gt;Repeat these steps for the other databases&lt;/I&gt;&lt;/B&gt;)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;9. Perform only ONE of the following&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;9a.&amp;nbsp;FOR v10.10+ =&amp;nbsp;&lt;/B&gt;After restoring all of the databases, you need to authorize them in the system.&lt;BR /&gt;- Right click on VFMNGDB5 &amp;gt; New Query&lt;BR /&gt;- Write the command "EXEC dbo.usp_VfScheduledJobReviveAfterRecovery"&lt;BR /&gt;- Click on !Execute in the toolbar (or hit F5)&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;9b. FOR v5.5-10.9 =&amp;nbsp;&lt;/B&gt;&lt;/FONT&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Manually !Execute&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;the following query against&amp;nbsp;&lt;B&gt;all&amp;nbsp;&lt;/B&gt;EPM Databases (&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;B&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFMNGDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFNESTDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFSTAGEDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;VFSTATDB5,&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;VFEVENTSDB5&lt;/B&gt;)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="background-color: #ffffff;"&gt;&lt;SPAN style="background-color: #ffffff;"&gt;DECLARE @DbName nvarchar(max), @Principal sysname&amp;nbsp;&lt;BR /&gt;SELECT @DbName = CONVERT(nvarchar(max), DB_NAME())&amp;nbsp;&lt;BR /&gt;SELECT @Principal = name&amp;nbsp;&lt;BR /&gt;FROM sys.server_principals&amp;nbsp;&lt;BR /&gt;WHERE (sid = 0x01)&amp;nbsp;&lt;BR /&gt;EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON')&amp;nbsp;&lt;BR /&gt;EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];')&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 17 Aug 2020 10:11:34 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/how-to-restore-epm-database-from-backup/ta-p/1429996</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-08-17T10:11:34Z</dc:date>
    </item>
  </channel>
</rss>

