Installation guide

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" – for Adaptive Server version 15.7 ESD #1.
• "GA" – for Adaptive Server version 15.7.
• @verbose – when used, displays the output in the verbose mode.
For example:
1> sp_downgrade_esd tempdb, esd1
2> go
Reverting database 'tempdb' to 'ESD1'.
Database 'tempdb' is now suitable for use by ESD1.
(return status = 0)
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 ESD #2.
You may now start the Adaptive Server 15.7 or 15.7 ESD #1 dataserver with Adaptive Server
15.7 ESD #2 quorum devices.
See also
•
Downgrading from Adaptive Server 15.7 ESD #2 on page 106
• Dumping a 15.7 ESD #2 Database to Load into a 15.7 or 15.7 ESD #1 Adaptive Server on
page 110
CHAPTER 11: Adaptive Server Downgrades
Installation Guide 109