TLFYDGL-ASEINSTALL-05-Feng Zhiwei @ 2003-8-6
Sybase ASE Installation Guide (Simple Edition)
[Ready to work]
1. Establish a preset directory, if there is a second partition, create to the second partition (d :), otherwise in the first partition (C :)
Store database file area description
PowerDB database file
Power_Backup backup file
My Share Sybase installation file backup, then share
2. Copy the Sybase ASE installation file to the local, such as the network mapping drive
3. Install the database management system
4. View if the computer name is in line with the system specification, the name of the pinyin, if not correct, then reboot the computer after modifying the computer.
[start installation]
1. Install the Sybase Adaptive Server Enterprise 11.9 server side, restart your computer after installation
2. Modify the Locales.dat in the Locales.dat in the ASE installation directory, ISO_1 is changed to CP850
3. Configure Windows services to automatically start ASE primary services and backup services.
4. Configure the server:
1. Configure the data server:
1. Modify the Physical Memory> Total Memory value (physical memory / 3) * 1024
2. Modify the Disk I / O> Disk I / O Structure value 1024
3. Restart the database server
4. Add a cache: named POWER_CACHE, size is 2/3 of available cache
5. Restart the database server
6. Add database device Addtion_tempuse, size 200MB, location powerdb / addtion_tempuse.dat
7. Since the Tempdb, the SybsystemProcs system library is allocated from Addtion_Tempuse, respectively.
8. Restart the database server
3. Create a database TPower
1. Create a data device
Equipment name size
Power_DataA 600 Data
Power_DataB 600 Data
Power_log 200 log
2. Modify the data device properties.
1. The default device removal in the parameter of the Master device
2. The default device is selected in the parameter of the 2.Power_DataA device
3. The default device is selected in the parameter of the Power_DATAB device
3. Create a database TPower, which contains the device
Equipment name size
Power_DataA 600 Data
Power_DataB 600 Data
Power_log 200 log
4. Assign cache Power_Cache to TPower database
5. Restore existing databases
6. View the database TPower property, "Allow Select Enter / Batch Copy" in the Database Properties page, and "Truncate Log on Checkpoint"
[Automatic backup]
1. Configure the database management system
2. Test Automatic Backup ASE
3. Configure the scheduled task so that Automatic Backup ASE starts at 3:00 every day.
