Rockwell Automation Emonitor with a Gupta Multi-User Database - Manual (Page 35)

5 • D ATABASE MAINTENANCE
31
•
•
•
• •
This command may take some time depending on the size of your database, so please
be patient. Run this command on both the Entek and the Econfig databases.
Running the Gupta SQLBase Server as a program
By default, the Gupta SQLBase Server runs as a Windows service. This means the Server
starts when you start Windows, and you cannot close the SQLBase Server program (the
Exit button is disabled). You can change the way the Server starts, so that it only starts
when it is needed by Emonitor.
1. If you are using a network version of Emonitor, make sure that all users are logged out
of Emonitor, and that no one is accessing the database with SQLTalk or another utility.
2. Start the Gupta SQLBase Management Console. Select Start > Program Files >
Gupta > SQLBase 9.0.1 > SQLBase Management Console.
3. Expand the Console Root by double clicking it.
4. Right-click the database server name. The default name is Server1. Select Stop to
stop the database server.
5. Right-click Service Properties. Select Startup Type > Disabled. This means the
database server will only start when you start Emonitor.
You can also run the SQLBase Server as a service without displaying the Server
Console. Right-click Service Properties, and then select Server Console > Off.
6. Close the SQLBase Management Console. The next time you start Windows, the
SQLBase Server will not automatically start. It will only start when you start
Emonitor, or manually start the server by selecting Start > Program Files > Gupta >
SQLBase 9.0.1 > SQLBase Database Engine.