How to Load the master Database from Backup

This is a three-step procedure:

  1. Put Adaptive Server in single-user mode. Refer to “How to Start Adaptive Server in Single-User Mode”.

  2. Start isql as sa.

  3. Execute these commands:

    1> load database master
    2> from logical_dump_device_name
    3> go
    

    OR
    

    1> load database master
    2> from “physical_dump_device_name”
    3> go
    

Alternatively, if the database was dumped to a remote site, refer to “load database” in the Reference Manual for information about loading the master database.

Once the master database is loaded successfully, Adaptive Server automatically shuts itself down and the isql session exits with the following message:

DB-Library: Unexpected EOF from SQL Server.