Installation guide

and print on the console. Save the output of sp_downgrade 'downgrade', <version> into a
file, so the passwords are not lost. To regenerate the sa password, restart the downgraded
server with -psa. See sp_passwordpolicy in Reference Manual: Procedures .
6.
To restore the original messages for the earlier version of Adaptive Server, run this script
after downgrading the server:
isql -Usa -Psa_password -irestoremsgs.ebf
7.
Run any post-downgrade scripts that may be applicable to your site, including
installmaster and instmsgs.ebf.
If you have not used any 15.7 ESD #2 functionality, this completes the primary downgrade
process.
See also
•
Post-Downgrade Tasks for Adaptive Server on page 114
•
Additional Considerations for New Features Used on page 111
• Downgrading Job Scheduler on page 112
Downgrading to an Earlier Version of Adaptive Server 15.7
Use sp_downgrade_esd to downgrade your installation of Adaptive Server 15.7 ESD #2 to
Adaptive Server 15.7 or 15.7 ESD #1.
Prerequisites
To use sp_downgrade_esd, you must have sa_role, and be in the master database.
Task
Use the sp_downgrade_esd system procedure only when downgrading from Adaptive Server
version 15.7 ESD #2 to either 15.7 or 15.7 ESD #1; sp_downgrade_esd does not run on any
other version of Adaptive Server. To downgrade to a version earlier than 15.7, use
sp_downgrade.
1.
Restart Adaptive Server in single-user mode by specifying the -m option.
2.
In a loop, run sp_downgrade_esd on each database. You need not downgrade temporary
databases. These include tempdb as well as user-created temporary databases, as they are
re-created from a template database when Adaptive Server starts. To downgrade your
entire installation, run it several times, once per database in your installation.
Note: If you are downgrading the entire installation, perform sp_downgrade_esd on all of
your non-temporary databases, then downgrade the master database last.
The syntax for sp_downgrade_esd is:
sp_downgrade_esd @db_name [, @esd [, @verbose]]
CHAPTER 11: Adaptive Server Downgrades
108 Adaptive Server Enterprise