The following tasks allow the System Administrator to create and configure a SmartPlant Instrumentation database for SQL Server running the DB Setup Utility, supplied with SmartPlant Instrumentation. You can create one SmartPlant Instrumentation database per database setup session. After a successful database setup session, you can log on to the Administration module of SmartPlant Instrumentation as System Administrator and initialize SmartPlant Instrumentation domains in your database. For a complete list of tasks, click the appropriate topic on the Contents tab and then click the procedure that you want.
Set Up a SmartPlant Instrumentation Database for SQL Server
Use this procedure to run SmartPlant Instrumentation database setup in your SQL Server instance. You define filegroups and other parameters required for the SmartPlant Instrumentation database. The setup provides default parameters and values that you can accept or modify. The default file sizes are recommended as initial values. When connecting to the SQL Server database, you provide a logon name and a logon password. This logon information is different from the logon information required to log on to SmartPlant Instrumentation. You define the SQL Server database server logon information during this procedure. For more information, see Set Up a Smart Instrumentation Database for SQL Server (see Set Up a SmartPlant Instrumentation Database for SQL Server).
Clean Up the SQL Server Database
Use this procedure to clean up the SQL Server database by deleting SmartPlant Instrumentation database objects created during a specific database setup session. You must perform this procedure if a database setup did not complete successfully and you want to run the same setup again. You clean up the database using SQL Server tools. For more information, see Clean Up the SQL Server Database.