Search code examples
databaset-sqlsybasesap-ase

Master Device Is Lost and Valid Dump Does Not Exist (SYBASE ASE 15.0)


I have the following issue , the physical device of the master db is damaged and a valid dump of master doesn´t exist , I´m using ASE 15.0 version .

How can a recover my master db and my users and logins ?


Solution

  • If the devices of the other databases are not damaged and you have the device creation scripts you can restore the devices with disk reinit and disk refit , after that just query the users from each database from sysusers , get the name , the creation id and add them with sp_loggin in the correct order.