How to restore EPM database from backup

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Endpoint Privilege Manager (EPM) Articles
3 min read
L2 Linker
No ratings
Q: How do I restore EPM databases from backup?

 

Steps

A:

1. Open IIS Manager and stop your server.

2. login to Microsoft SQL Server Management Studio

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 database)

4. Select your database backup files 

- begin with restoring "VFSTAGEDB5", then "VFMNGDB5", then "VFNESTDB5", then "VFSTATDB5", then "VFEVENTSDB5"

5. Right click VFSTAGEDB5 -> Tasks -> Restore -> Database...

6. Select the backup sets to restore

7. Under Options > Select check-box to "Overwrite the existing database (WITH REPLACE)"

8. The restore of the database should complete successful (Repeat these steps for the other databases)

9. Perform only ONE of the following

a. FOR  EPM v10.10+ = After restoring all of the databases, you need to authorize them in the system.
- Right click on VFMNGDB5 > New Query
- Write the command
EXEC dbo.usp_VfScheduledJobReviveAfterRecovery
- Click on !Execute in the toolbar (or hit F5)

b. FOR EPM v5.5-10.9 = Manually !Execute the following query against all EPM Databases (VFMNGDB5, VFNESTDB5, VFSTAGEDB5, VFSTATDB5, VFEVENTSDB5)
DECLARE @DbName nvarchar(max), @Principal sysname 
SELECT @DbName = CONVERT(nvarchar(max), DB_NAME()) 
SELECT @Principal = name 
FROM sys.server_principals 
WHERE (sid = 0x01) 
EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON') 
EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];')

Q:

How do I restore database from backup?

A:

1. Open IIS Manager and stop your server.

2. login to Microsoft SQL Server Management Studio

3. Right click VFMNGDB 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 database)

4. Right click VFMNGDB -> Tasks -> Restore -> Database...

5. Select your database backup files 

- begin with restoring "VFSTAGEDB5", then "VFMNGDB5", then "VFNESTDB5", then "VFSTATDB5", then "VFEVENTSDB5")

6. Select the backup sets to restore

7. Under Options > Select check-box to "Overwrite the existing database (WITH REPLACE)"

8. The restore of the database should complete successful (Repeat these steps for the other databases)

9. Perform only ONE of the following

9a. FOR v10.10+ = After restoring all of the databases, you need to authorize them in the system.
- Right click on VFMNGDB5 > New Query
- Write the command "EXEC dbo.usp_VfScheduledJobReviveAfterRecovery"
- Click on !Execute in the toolbar (or hit F5)

9b. FOR v5.5-10.9 = 
Manually !Execute the following query against all EPM Databases (VFMNGDB5, VFNESTDB5, VFSTAGEDB5, VFSTATDB5, VFEVENTSDB5)

DECLARE @DbName nvarchar(max), @Principal sysname 
SELECT @DbName = CONVERT(nvarchar(max), DB_NAME()) 
SELECT @Principal = name 
FROM sys.server_principals 
WHERE (sid = 0x01) 
EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON') 
EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];')

Rate this article:
  • 2774 Views
  • 0 comments
  • 0 Likes
Article Dashboard
Version history
Last Updated:
‎08-17-2020 03:11 AM
Updated by: