Captain
Captain
204 views

(OMW) Support Tip: Shrink transaction log of Openview database

      In case the transaction log file of the Openview database has been increased to a very large size.  We can reduce the size of the log file by shrinking the log file as following:

1) Backup the OpenView database online incase of any failure:

cscript "%OvInstallDir%\support\backup_openview.vbs"

you can get detail from online help: “Back up the HPOM database” and “Restore the HPOM Database”

2) disable/stop the services:

   vpstat -3 –r disable

3) shrink the transaction log:

logon sql:

osql -E -S  <sql server>  -dopenview

  1. BACKUP LOG openview  TO DISK = '<BackupFile>'

<BackupFile> is a placeholder for the full path of the backup file.

  1. DBCC SHRINKFILE (Openview_log, <target size of the log>)

For detail, please see:  

  http://support.microsoft.com/kb/907511/en-us

4)          restart the services:

vpstat -3 –r enable

 

Micro Focus Software Support

The views expressed in my contributions are my own and do not necessarily reflect the views and strategy of Micro Focus.

If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
0 Replies
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.