Change the properties for the runtime database

You can view or change the properties for the Runtime database, such as the paths to the database files and transactions logs and the permissions on the database.

To view/change the Runtime database properties

1. In Microsoft SQL Server Management Studio, expand the AVEVA Historian, and then expand Databases.

2. Right-click the Runtime database and then click Properties. The Database Properties dialog box appears.

   

3. To view directory in which the database file and transaction log resides, as well as view the current size of the file and log, in the Select a page pane, click Files.

   Note: To see the database file in the Windows Explorer, look in the \DATA directory of the main Microsoft SQL Server directory.

4. Using the options in the Runtime Properties dialog box, you can recalculate the space available in the database or the transaction log. You can also set database options and grant and revoke statement permissions for database users and groups.

   Important: Do not modify the default permissions for the default Historian logins and users, as this negatively affects the system.

   For more information on managing databases, see your Microsoft SQL Server Management Studio documentation.

5. Click OK.