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

I NSTALLING E MONITOR S OFTWARE WITH A G UPTA SQLB ASE M ULTI -U SER D ATABASE
32
• •
•
•
•
Backing up your data
How often should I back up my data?
You should back up as often as you can afford to lose data. If you can lose a week’s worth
of data, back up once a week. If you need to have all of your data from each day, back up
daily.
What files and directories do I need to back up?
The Gupta SQLBase database directories should be backed up. These database directories
contain the individual Gupta SQLBase database files (.dbs). Typically the database
directories are stored in subdirectories of the main Gupta SQLBase directory. Simply
copy the directories and files within the directories.
For example, to back up the Entek database, you would copy the Entek directory which
contains the entek.dbs file (copy both the .dbs file and any other files that are in the
directory).
You also need to back up the Econfig directory containing the Econfig database.
What is the correct backup procedure for SQLBase
databases?
1. Shut down Emonitor.
2. From the Start menu, point to Programs, then to Gupta, then to SQLBase 9.0.1, then
click SQLTalk Interactive SQL.
3. From the Session menu, click Connect, or press F2.
4. Enter the database name, username and password for your database. The default user
name is ENTEK, and the default password is EUSER.
5. Click Connect. Your database name should appear in the Current Connections box.
6. Click Close to close the Connect dialog.
7. In the Input Window (top pane), type the following, including the semicolon:
check database;
8. Press Shift+F2 to execute the command. If the check is successful, SQLTalk displays
the message:
The name of the directory that contains the SQLTalk database has changed from Centura to
Gupta. The new database directory for Gupta SQLBase 9.0.1 is \Program
Files\Gupta\SQLBase901.