Restoring a database

The back up process of all GV STRATUS databases have been completed and backup locations already identified.
Ensure that previously existing databases with the same name have been deleted from the restore destination.
For the restore at a new standalone Database server, delete the previously installed GV STRATUS databases because they were automatically created during the initial installation via SiteConfig.

On the GV STRATUS Core server do the following:
1. In Internet Information Services (IIS) Manager, stop the IIS Web server.
2. In the Windows operating system Control Panel, stop all of the GV services.
Open and log in to Microsoft SQL Server Management Studio.
In the tree-view expand the Databases node and identify the databases of the GV STRATUS system to restore, which are the following:
- ISDB
- MediaFlow
- MediaFrame
- RulesEngine
- WfPersistence
Right-click on a database, and select Tasks | Restore | Database.
The Restore Database window opens.
In the Source section, select Device and click ....
Click Add, navigate to the database backup location, select the backup file, click OK and OK. If there are multiple backup files, check the date of the file and make sure you are selecting the correct file.
In the Destination section, select the database.
In the Restore plan section, select the checkbox under the Restore column to select the backup database to be restored.
In the Options page, do the following steps:
- In the Restore options section, check the box to Overwrite the existing database.
- In the Server connections section, check the box to Close existing connections to destination database, if possible.
Click OK.
Restart the GV STRATUS Core server.
The GV STRATUS database is now restored.
If you are switching database servers, start the IIS Web server in Internet Information Services (IIS) Manager.
On the GV STRATUS Control Panel, click Core | STRATUS Core Services | Primary Site and select the Database Server Machine from the STRATUS Database Server drop-down list.
Changing the STRATUS Database Server setting on the GV STRATUS Control Panel starts the switch over process to the newly added standalone Database Server.
If there were changes to assets/metadata on the system since the database backup, select Core | Search Index Config in the GV STRATUS Control Panel and click Reset Index.