X hits on this document

53 views

0 shares

0 downloads

0 comments

16 / 22

  • 5.

    Click the Validate button to begin the validation check.

  • 6.

    When the validation is complete, click the OK button to close the Database Validate dialog box and

then click the Exit button to quit DBUtil. Backup Database

The Backup Database utility makes a copy of the database and transaction log files in another directory on the local drive. After the backup copies are made, the log file is restarted to prevent excessive size. A large log file consumes hard disk space and can eventually reduce system performance. E-Z Data, Inc. recommends running this utility weekly.

USING THIS UTILITY DOES NOT ELIMINATE THE NEED TO BACK UP THE DATA ON EXTERNAL MEDIA.

Running the Backup Database Utility

  • 1.

    If it is running, shut down the Sybase engine.

  • 2.

    From the Taskbar, click the Start button, point to Programs, Client Data System, and then click the

DBUtil icon.

3. This step only applies to users with multiple E-Z Data applications. Otherwise, skip to Step 4. From the E-Z Data Applications dialog box, select Client Data System and then click the OK button.)

  • 4.

    In the Database Utilities dialog box, under Databases, select the names of one or more databases.

  • 5.

    Under Tools, ensure that the Backup Database option is selected.

  • 6.

    Click the Backup button to begin the backup.

  • 7.

    When the backup is complete, click the Exit button to quit DBUtil.

Database Rebuild

The Database Rebuild option recreates indexes and maintains database integrity. Periodically, database indexes need to be recreated, especially after data imports, conversions or heavy daily use. E-Z Data, Inc. recommends running this utility monthly.

The preferred method for rebuilding a database is to run DBUtil at the server/workstation. If DBUtil is to be run from a workstation, DBENG7.EXE needs to be copied from the SQL Anywhere 7\Win32 directory on the server to the SQL Anywhere 7\Win32 directory on the workstation.

Running the Database Rebuild Utility

  • 1.

    From the Taskbar, click the Start button, point to Programs, Client Data System, and then click the DBUtil icon.

  • 2.

    This step only applies to users with multiple E-Z Data applications. Otherwise, skip to Step 3. From the E-Z Data Applications dialog box, select Client Data System and then click the OK button.

3.

In the Database Utilities dialog box, select one of the Database names (except for DEMO). The DEMO database does not need to be rebuilt.

Note:

Multiple databases can be rebuilt simultaneously, but this is not recommended.

Client Data System® v4.3 - Installation Guide for Workstations Revised: 10-11-04 Page 12

Document info
Document views53
Page views53
Page last viewedMon Dec 05 12:12:09 UTC 2016
Pages22
Paragraphs409
Words5660

Comments