If you have not used sp_diskdefault to change the status of the master device or to specify another default device, the scripts install the sample databases on the master device. Sybase does not recommend this configuration because it uses valuable space that is best used for system tables. Each sample database requires 3MB on a 2K server, and multiples of 3MB on a 4K, 6K, 8K, and 12K server on your database device.
To avoid installing sample databases on the master device, either:
Use sp_diskdefault to specify a default device other than the master device. For information on sp_diskdefault, see the Reference Manual.
Modify each sample database installation script to specify a different device.
Running the database scripts
Start Adaptive Server.
Determine the type (raw partition, logical volume, operating system file, and so on) and location of the device where you will be storing the pubs2 and pubs3 databases. You will need to provide this information later.
Make a copy of the original installpubs2 and installpubs3 scripts. Be sure you can access the copies, in case you have problems with the edited scripts.
Use a text editor to edit the script, if necessary, to specify a default device other than the master device, or use sp_diskdefault.
where server_name represents the destination server for the database and script_name is the full path to and file name of the script to run.
For more information about running these scripts, see Configuring Adaptive Server Enterprise.
