Book Description

Systems administrators are responsible for overall performance at the server level, while database administrators handle access, consistency, and performance within the database. Administrator's Guide to Sybase ASE 12.5 provides all administrators with an authoritative guide to the latest version of this important SQL enterprise database.After reading this book, administrators should be able to perform any task that encompasses the creation or maintenance of a server. The appendixes include a Certified Sybase Professional DBA sample test, troubleshooting tips, and articles on tuning, fragmentation, and disaster recovery.The companion CD-ROM contains the 60-day evaluation version of Sybase Adaptive Server Enterprise 12.5 for NT.Topics include installing Sybase ASE and establishing connectivity; creating and dropping databases and devices; protecting database devices through mirroring; and backing up and restoring databases. Additionally, the authors discuss transaction logging and managing the transaction log; enabling security through the use of passwords, permissions, and auditing; using the Resource Governor and Logical Process Manager; and troubleshooting and preventative maintenance.