alter database QAS off logQAS_1='20384M'
go;
alter database QAS off logQAS_1 = '20384M'
go;
alter database QAS log off logQAS_1='20384M'
go;
sp_helpdb QAS
go;
alter database QAS log off logQAS_2='20480M'
go;
disk resize name = 'logQAS_00', size = '5120M'
go;
alter database QAS log on logQAS_00 = '5120M'
go;
alter database QAS log off logQAS_2='20480M'
go;
sp_dropdevice logQAS_2
go;
alter database QAS log off logQAS_1='20384M'
go;
sp_dropdevice logQAS_1
go;
disk init name = logQAS_1, physname='F:\sybase\QAS\saplog_1\logQAS_1.dat', size = '20480M'
go
;
alter database QAS log on logQAS_1 = '20480M'
go;
sp_dropdevice logQAS_00
go;
alter database QAS log off logQAS_00='25600M'
go;
disk resize name = 'logQAS_1', size = '5120M'
go;
alter database QAS log on logQAS_1 = '5120M'
go;
alter database QAS log off logQAS_00='25600M'
go;
sp_dropdevice logQAS_00
go;
sp_helpdb QAS
go;
sp_dboption QAS, 'trunc',true
go;
dump transaction QAS to 'G:\QAS_TRN.dmp' with compession = 101
go;
dump transaction QAS to 'G:\QAS_TRN.dmp' with compression = 101
go
;
sp_helpdevice logQAS_01
go;
sp_helpdevice logQAS_1
go;
use master
go
;

sp_helpdb
go;
dump database sybmgmtdb to 'D:\sybmgmtdb_db.dmp' with compression = 101
go
dump transaction sybmgmtdb to 'D:\sybmgmtdb_tn.dmp' with compression = 101
go;
sp_helpdb
go
;

dump database sybmgmtdb to 'D:\sybmgmtdb_db.dmp' with compression = 101
go;
dump database sybmgmtdb to 'C:\sybmgmtdb_db.dmp' with compression = 101
go
dump transaction sybmgmtdb to 'C:\sybmgmtdb_tn.dmp' with compression = 101
go;
dump database master to 'C:\master_db.dmp' with compression = 101
go;
sp_helpdb sybmgmtdb
go;
disk resize name = 'sybmgmtdev', size = '200M'
go
alter database sybmgmtdb on sybmgmtdev = '200M'
go;
use master
go
sp_helpdb saptools
go;
dump database saptools to 'C:\saptools_db.dmp' with comprsssion = 101
go
dump tran saptools to 'C:\saptools_tn.dmp' with compression = 101
go;
dump database saptools to 'C:\saptools_db.dmp' with compression = 101
go
dump tran saptools to 'C:\saptools_tn.dmp' with compression = 101
go;
sp_helpdb saptools
go;
sp_helpdevice
go;

disk resize name = 'saptools', size = '512M'
go
alter database saptools on datasaptools_1 = '256M'
go
alter database saptools log on logsaptools_1 = '256M'
go;
disk resize name = 'datasaptools_1', size = '256M'
go
disk resize name = 'logsaptools_1', size = '256M'
go;
alter database saptools on datasaptools_1 = '256M'
go
alter database saptools log on logsaptools_1 = '256M'
go;
sp_configure 'number of locks'
go;
sp_configure 'number of locks',25000000
go;

sp_configure 'max memory'
go;
sp_configure 'max memory',7864320
go;
sp_configure 'number of locks',25000000
go;
sp_configure 'number of locks',30000000
go;
sp_configure 'max memory',8388608
go;
sp_configure 'number of locks',30000000
go;