3/20/2006 SQL Server Query Timeout
Follow the following steps to eliminate the Timeout error:
  1. For Windows 2000 and Windows XP, open Windows Explorer and browse to
    C:\Documents and Settings\ and open the folder of the user currently logged in.
  2. In the users folder there is another folder called "Application Data", expand this folder. Click on the sub folder called "Archibus".
  3. There should be a file in this folder called "AfmUserPreferences.ini". This file contains the information with regards to user settings and the database timeouts.
  4. a. If the [Internal] section does not exist, add:

    [Internal]
    SQL Server Query Timeout = 0

    b. If the Internal section exists, add this as the last line of the Internal section:

    SQL Server Query Timeout = 0

  5. Save and close the file.
  6. Close all instances of Archibus and restart the application.
3/20/2006 How To Schedule Sybase DB Backups
Put the following into a BAT file and have an NT schedule run it:
"D:\Program Files\Sybase\SQL Anywhere 8\win32\dbbackup.exe" -d -x -y -c UID=dba;PWD=sql;dbf=[DBNAME] [DIRECTORY]

DBNAME is the actual name and extension of the database
DIRECTORY is the location where the backup is to go.

We typically create 7 of these, one for each day of the week pointing to a different backup directory.

Note: Command line utilities are not supported in Netware.