%OvDataDir%\datafiles\<database_instance>
The database consists of several physical files, as shown in the table:
File Name | Purpose | |
openview.mdf
|
Primary partition for system tables | |
store.ndf
|
Store tables and indexes | |
pmad.ndf
|
Policy Management and Deployment tables and indexes | |
msgaction_dat.ndf
|
Message Action Server tables | |
msgaction_idx.ndf
|
Message Action Server indexes | |
role.ndf
|
Security Server Role tables and indexes |
To achieve better performance by utilizing parallel disk I/Os, you should distribute database files and log files to separate disk drives.
attachdb.sql and detachdb.sql
. Scripts are located in
the
%OvInstallDir%\lbin\OvOW\ServerConsoleInstall\dbscripts
directory.osql -S<database_instance> -E -i detachdb.sql
The operation is successful if there is no error message.
Make a copy of the attachdb.sql
script, as
shown:
copy attachdb.sql myattach.sql
myattach.sql
, replacing
the lines containing NEW_LOCATION with the actual physical location
of the file.
osql -S<database_instance> -E -i myattach.sql
You should see the message "Successfully attached database openview."
Related Topics:
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at webmaster@systemmanager.forsenergy.ru to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.