Restoration via SQL Server Management Studio

You should only restore the ServerView database from backup files to the same Operations Manager version. The SQL Server version must either be the same or higher on the server where the backup is restored.

If you restore to the wrong version, Operations Manager will not work, either immediately or after the next upgrade installation. Please note: Restoring the database requires membership in the "sysadmin" server role of SQL Server.

Find out the version of the installed Operations Manager: 1. SelectControl Panel–Programs and Features. 2. SelectFujitsu ServerView Operations Manager. Find out the Operations Manager version in the backup files:

3. Restore the backup files into a test database, see"Checking the database backup " on page 191. Please make sure there is enough disk space, as the filesRECOVERYTEST.mdfandRECOVERYTEST.LDFwill be created. 4. Start SQL Server Management Studio.

5. Connect to the SQL Server instance. 6. SelectDatabases–RECOVERYTEST. 7. SelectTables–dbo._Property.

8. SelectOpen TableorSelect Top 1000 rowsfrom the context menu. 9. See rowParentVersion. Is the value in columnValuethe same as the

installed Operations Manager version determined before? If this is true, the first prerequisite for restoring is achieved. Find out the installed SQL Server version:

10. Select theNew Querybutton and type:

select @@version

GO

Find out the SQL Server version in the backup files: 11. SelectDatabases–RECOVERYTEST.

12. SelectPropertiesfrom the context menu. 13. SelectOptions.

In fieldCompatibility levelyou see the SQL Server used during backup. 14. If the value of@@versionis the same or higher than the value in the field

Compatibility levelthe second prerequisite is achieved and restoration can be executed.

To restore the ServerView database and, if available, the transaction logs, proceed as follows:

1. Restrict the access to the ServerView database. 1. Start SQL Server Management Studio.

2. Connect with the SQL Server instance and selectDatabases– ServerViewDB.

3. SelectPropertiesfrom the context menu.

4. Select theOptionspage and, underRestrict Access, select the entry RESTRICTED_USER. ClickOKfollowed byYES.

2. The servicesServerView Services,ServerView JBoss Application Server 7 andServerView Download Servicemust be stopped:

1. SelectAdministrative Tools–Services.

2. Select the appropriate service and then selectStopfrom the context. 3. Restore from the database backup:

1. ClickDatabasesand then selectRestore Databases …from the context menu.

2. The Restore Databases window opens:

1. On theGeneralpage, enter the nameServerViewDBormsdbin theTo databasefield or select the name from the list.

2. Select the optionFrom device. 3. Click the...button.

4. Add the database backupServerViewDBData.bakfrom the appropriate storage location and then clickOK.

3. Select the database backup to be restored:

InSelect the backup sets to restore, click the box in theRestore column.

4. Switch to theOptionspage.

5. Select the optionsOverwrite the existing database.

6. If no transaction log backupServerViewDBLog.bakis available, click OK. Otherwise, select the optionOverwrite the existing database and Leave database nonoperational and do not roll back

uncommitted transactions. Additional transaction logs can be restored.

7. ClickOKand thenOKagain.

Restoration of the database begins. In the Object Explorer you will see the messageServerViewDB (Restoring…).

4. Restore the transaction logs, if available:

1. ClickDatabasesand then selectRestore Databases …from the context menu.

2. TheRestore Databasewindow opens.

3. On theGeneralpage, in theTo Databasefield select the name ServerViewDBfrom the list.

4. Select the optionFrom Device. 5. Click the...button.

6. Add the transaction log fileServerViewDBLog.bakfrom the appropriate storage location and then clickOK.

7. Select the database backup to be restored:

InSelect the backup sets to restore, click the box in theRestore column.

8. Switch to theOptionspage.

9. Select the optionOverwrite the existing database.

If you want to restore further transaction logs, select the optionLeave the database non-operational and do not roll back uncommitted transactions. Additional transaction logs can be restored. If you want to restore the last transaction log, select the optionLeave the database ready to use ... Additional transaction logs cannot be restored.

10. ClickOKand thenOKagain.

Once the last transaction log has been restored, the database status must be normal again. The add-on (Restoring…)is no longer displayed in the Object Explorer.

If the backup has been restored from a different system you have to adapt the JBoss Service Logon:

1. Find out the value of theServer_Instanceparameter in the

configuration fileServerViewDB.ini. The configuration file is located in the<windir>directory.

2. Find out the value of<server_name\user_name>and use it in the next step:

1. OpenAdministrative Tools-Servicesand scroll to the service ServerView JBoss Application Server 7. ColumnLog On As contains the required value.

3. Open SQL Server Management Studio and connect to<Server_ Instance>:

1. SelectSecurity-Logins.

Look for<server_name>\<user_name>and note the spelling and upper and lower case.

2. SelectDatabases-ServerViewDB-Security-Users.

If you can find<server_name>\<user_name>click theNew Query button, type the following command (type the [] brackets literally and pay attention to the correct spelling) and press theExecute button:

USE ServerViewDB

ALTER USER [<server_name\user_name>] WITH LOGIN = [<server_name\user_name>];

GO

If you cannot find<server_name>\<user_name>click theNew Querybutton, type the following command (type the [] brackets literally and pay attention to the correct spelling) and press the Executebutton:

USE ServerViewDB

CREATE USER [<server_name>\<user_name>]; GO

sp_addrolemember 'db_owner', [<server_name>\<user_ name>];

The servicesServerView Services,ServerView JBoss Application Server 7, and ServerView Download Servicemust be restarted:

1. SelectAdministrative Tools–Services.

2. Select the appropriate service and then selectRestartfrom the context menu.

Please wait about five minutes until all JBoss processes are completely restarted. It is now possible to access the ServerView database via Operations Manager again.