Adding the Maintenance User

Add the maintenance user login name for the standby database to both the standby and the active data servers.

  1. In the standby data server, execute the sp_addlogin system procedure to create the maintenance user login name.

    See the Adaptive Server Enterprise System Administration Guide for more information about using sp_addlogin.

  2. In the active data server, execute sp_addlogin to create the same maintenance user login name that you created in the standby data server.

    When you set up the standby database using the dump and load commands, the sysusers table is loaded into the standby database along with the other data from the active database.