Step 2: Build a new master device

Before you run dataserver, check your most recent copy of sysusages. If it has only one line for dbid 1, your master database has only one disk allocation piece, and you can go to “Step 5: Check your Backup Server sysservers information”.

Shut down Adaptive Server, if it is running, and rebuild the master device. When rebuilding the master device, you must specify the device size.

Before you begin, it is important that you remember to:

Run dataserver (UNIX) or sqlsrvr (Windows NT) to build a new master device and to install a copy of a “generic” master database. Give the full name and full size for your master device.

NoteYou must give dataserver a size as large as or larger than the size originally used to configure Adaptive Server. If the size is too small, you will get error messages when you try to load your databases.

The following example rebuilds a 17MB master device.

After you run dataserver, the password for the default “sa” account reverts to NULL.

For details on the dataserver utility, see the Utility Guide.