Finding the Appropriate Recovery Scenario

Use the following table to determine where to look in this chapter for information on your system database recovery problem.

If	And	And	Then see
The master database is corrupt	Adaptive Server does not start	A valid dump of the master database exists	“Valid Dump of the master Database Exists”
The master database is corrupt	Adaptive Server does not start	A valid dump of the master database does not exist	“Valid Dump of the master Database Does Not Exist”
The master database is corrupt	Adaptive Server starts	A valid dump of the master database exists	“Valid Dump of the master Database Exists”
The master database is corrupt	Adaptive Server starts	A valid dump of the master database does not exist	“Manually Rebuilding Adaptive Server with bcp”
The master device is completely lost	A valid dump of the master database exists		“Master Device Is Lost and Valid Dump Exists”
The master device is completely lost	A valid dump of the master database does not exist		“Master Device Is Lost and Valid Dump Does Not Exist”
The model database is lost or corrupted			“The model Database Is Lost or Corrupted”
You have lost a device, other than the master device, that contained pieces of tempdb			“Non-Master Device Containing Pieces of tempdb Is Lost”
The master device is going bad			“Master Device Is Going Bad”
Adaptive Server does not start after you have made configuration changes			“Adaptive Server Does Not Start After Altering Configuration”

Most of these problems (with the exception of “You have lost a device, other than the master device, that contained pieces of tempdb”) can also be addressed with the procedure for “Manually Rebuilding Adaptive Server with bcp”.

If you need to undertake recovery and a valid dump of master exists, but your server uses a non-default sort order, be sure to follow the instructions in “Valid Dump with Non-Default Sort Order.”