Downgrading to an Earlier Version of Adaptive Server 15.7

Use sp_downgrade_esd to downgrade your installation of Adaptive Server 15.7 SP100 to Adaptive Server 15.7 or an ESD version of 15.7.

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 sp_downgrade_esd for each 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]] 

   where:

   • @db_name – is the name of the database you are downgrading
   • @esd – is the ESD number you are downgrading to. The valid options are:
     • "ESD1", "ESD2", "ESD3", or "ESD4". You can also include the # symbol, such as"ESD#1" – for Adaptive Server version 15.7 ESDs #1 through #4.
     • "GA" – for Adaptive Server version 15.7.
   • @verbose – when used, displays the output in the verbose mode.

   For example:

   1> sp_downgrade_esd sybsystemprocs, esd1
   2> go
   Reverting database 'sybsystemprocs' to 'ESD1'.
   Database 'sybsystemprocs' is now suitable for use by ESD1.
   (return status = 0)
   1>
   2> sp_downgrade_esd sybsystemdb, esd1
   3> go
   Reverting database 'sybsystemdb' to 'ESD1'.
   Database 'sybsystemdb' is now suitable for use by ESD1.
   (return status = 0)
   1> sp_downgrade_esd model, esd1
   2> go
   Reverting database 'model' to 'ESD1'.
   Database 'model' is now suitable for use by ESD1.
   (return status = 0)
   1> sp_downgrade_esd MYASE_tdb_1, esd1
   2> go
   Reverting database 'MYASE_tdb_1' to 'ESD1'.
   Database 'LUMINOUS_tdb_1' is now suitable for use by ESD1.
   (return status = 0)
   1> sp_downgrade_esd master, esd1
   2> go
   Reverting database 'master' to 'ESD1'.
   Database 'master' is now suitable for use by ESD1.
   (return status = 0)
   1> shutdown
   2> go

3. Shut down Adaptive Server 15.7 SP100.
4. Start the Adaptive Server 15.7 or 15.7 ESD dataserver with Adaptive Server 15.7 SP100 quorum devices.