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

[Jindong Zeng]

      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