Verify that tempdb has been correctly reset, and alter the database as required to include any additional devices:
Log into Adaptive Server as the System Administrator:
% isql -Usa -Sserver_name -Ppassword
Verify that tempdb has one 2MB fragment for data and log on the master device:
1> sp_helpdb tempdb 2> go
Alter tempdb as required to extend the database onto the desired devices. For example:
1> alter database tempdb 2> on device_name = device_size 3> go
device_size is specified
in megabytes.
Back up the master database again, in case you need to restore from this point:
1> dump database master to "dump_device" 2> go
where dump_device is the name of the target dump device.
You can use sp_logdevice to place the transaction log on another device. The first 2MB of tempdb must remain on the master device, but future log space allocations will be made on the device specified by sp_logdevice.
