Administrator's Guide to Sybase ASE 12.5

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.

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.

After reading this book, you 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.

Jeffrey Garbus is a database consultant and the CEO of Soaring Eagle Consulting, Ltd., based in Tampa, Florida. He has spoken at user conferences, and has written many magazine articles and books. He is also the lead author for Jeffrey Garbus’ Official Sybase ASE 12.5 Library from Wordware Publishing, which includes Sybase ASE 12.5 Performance and Tuning and Sybase ASE 12.5 High Availability.

Alvin Chang is a technical trainer, author, and consultant working for Soaring Eagle Consulting. Penny Garbus is a technical writer and project lead for Soaring Eagle Consulting. Gary Tyrrell is a principal instructor with Sybase, where he teaches a wide variety of courses on ASE, ASA, Replication Server, SQL, and database design.