Determining adaptive server version, Backing up adaptive server – Sybase 15.0.2 User Manual

Page 50

Advertising
background image

Installing version 15.0.2 over an existing 15.x Adaptive Server

36

Adaptive Server Enterprise

Unified Agent

Unified Agent and Agent Management Console – Describes the Unified Agent,
which provides runtime services to manage, monitor and control distributed
Sybase resources.

Installing version 15.0.2 over an existing 15.x Adaptive
Server

Determining Adaptive Server version

Verify that your current Adaptive Server installation is at version 15.x by
running the following query from

isql

:

1> select @@version

2> go

If your server is not running, you can get a version string by running:

%SYBASE%\%SYBASE_ASE\bin\sqlsrvr.exe-v

If this shows that the Adaptive Server is not at version 15.x, you must upgrade
Adaptive Server. See Chapter 5, “Upgrading Adaptive Server.”

If your server is at a 15.x version level, you can begin installing Adaptive
Server 15.0.2.

Backing up Adaptive Server

Installing Adaptive Server version 15.0.2 overwrites the current Adaptive
Server software. Before installing, verify that your databases are error free and
that your $SYBASE directory is backed up.

To ensure that your database is error free, run

dbcc checkdb

,

dbcc checkcatalog

and

dbcc checkstorage

prior to loading any new Adaptive Server binaries,

including the master database. If the

dbcc

commands reveal problems, check

the Error Messages and Troubleshooting Guide for actions necessary to fix the
problem. If the error is not listed in the manual, call Sybase Technical Support.

After you have verified that your database is error free, back up your $SYBASE
directory in case you need to roll back to the original version of the software.

Advertising