How to restore the master device in sybase

The user cannot log on to the database because the syslogins table in the master database is deleted by mistake. However, if there is a backup of the master database, try to restore it. The following are the summary steps. 1. Back up the master database dumpdatabasemastertoe: \ ba

The user cannot log on to the database because the syslogins table in the master database is deleted by mistake. However, if there is a backup of the master database, try to restore it. The following are the summary steps. 1. Back up the master database dumpdatabasemastertoe: \ ba

Because the syslogins table in the master database is accidentally deleted, the user cannot log on to the database. The Hong Kong server is rented and the server space, but there is a backup of the master database. Try to restore the space in the United States. The following is a summary of the steps.

Dump database master to 'e: \ backup \ master. dat'

Sqlsrvr-d g: \ master. dat-b500M

Sqlsrvr-dg: \ master. dat-sDY-eg: \ sybase \ ASE-12_5 \ install \ errorlog-ig: \ sybase \ ini-Mg: \ sybase-m

-S service name

-E Error Log File Name

-I interface file directory

Alter database master on master = '280m'

Note that you can directly update the system table without the need for sp_configure 'Allow Update', 1

Select * from sysservers

Update sysservers set srvnetname = 'crm _ bs 'where srvid = 1

7 load master database backup

Load database master from 'e: \ backup \ master. dat'

This article is from the "myblog" blog. Be sure to keep this source