- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
EXEC dbo.usp_VfScheduledJobReviveAfterRecovery- Click on !Execute in the toolbar (or hit F5)
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 + '];')