兩邊的前次修訂版前次修改
下次修改 | 前次修改
|
sybase:move [2011/12/13 01:28] – jal | sybase:move [2011/12/13 03:43] (目前版本) – jal |
---|
| |
update sysservers set srvnetname='SYBASE_BS' where srvid=1 | update sysservers set srvnetname='SYBASE_BS' where srvid=1 |
| |
| |
| |
disk init name = "MIS_T_data01", physname = "D:\sybase\data\MIS_T_data01.dat", size = "2G" | disk init name = "MIS_T_data01", physname = "D:\sybase\data\MIS_T_data01.dat", size = "2G" |
disk init name = "MIS_T_log03", physname = "D:\sybase\data\MIS_T_log03.dat", size = "2G" | disk init name = "MIS_T_log03", physname = "D:\sybase\data\MIS_T_log03.dat", size = "2G" |
disk init name = "MIS_T_log04", physname = "D:\sybase\data\MIS_T_log04.dat", size = "2G" | disk init name = "MIS_T_log04", physname = "D:\sybase\data\MIS_T_log04.dat", size = "2G" |
| CREATE DATABASE MIS_T ON MIS_T_data01 = '2G', MIS_T_data02 = '2G', MIS_T_data03 = '2G', MIS_T_data04 = '2G', MIS_T_data05 = '2G', MIS_T_data06 = '2G' log ON MIS_T_log01 = '2G', MIS_T_log02 = '2G', MIS_T_log03 = '2G', MIS_T_log04 = '2G' for load |
| LOAD DATABASE MIS_T from "D:\backup\20111210\MIS_T_20111210060114.dmp" |
| |
| disk init name = "MIS_E_data01", physname = "D:\sybase\data\MIS_E_data01.dat", size = "2G" |
| disk init name = "MIS_E_log01", physname = "D:\sybase\data\MIS_E_log01.dat", size = "2G" |
| CREATE DATABASE MIS_E ON MIS_E_data01 = '2G' log ON MIS_E_log01 = '2G' for load |
| |
| disk init name = "MIS_E_TRG_data01", physname = "D:\sybase\data\MIS_E_TRG_data01.dat", size = "2G" |
| disk init name = "MIS_E_TRG_log01", physname = "D:\sybase\data\MIS_E_TRG_log01.dat", size = "2G" |
| CREATE DATABASE MIS_E_TRG ON MIS_E_TRG_data01 = '2G' log ON MIS_E_TRG_log01 = '2G' for load |
| |
| disk init name = "MIS_T_NEW_data01", physname = "D:\sybase\data\MIS_T_NEW_data01.dat", size = "2G" |
| disk init name = "MIS_T_NEW_log01", physname = "D:\sybase\data\MIS_T_NEW_log01.dat", size = "2G" |
| CREATE DATABASE MIS_E_NEW ON MIS_E_NEW_data01 = '2G' log ON MIS_E_NEW_log01 = '2G' for load |
| |
| disk init name = "MIS_T_NEW_TRG_data01", physname = "D:\sybase\data\MIS_T_NEW_TRG_data01.dat", size = "2G" |
| disk init name = "MIS_T_NEW_TRG_data02", physname = "D:\sybase\data\MIS_T_NEW_TRG_data02.dat", size = "2G" |
| disk init name = "MIS_T_NEW_TRG_log01", physname = "D:\sybase\data\MIS_T_NEW_TRG_log01.dat", size = "2G" |
| disk init name = "MIS_T_NEW_TRG_log02", physname = "D:\sybase\data\MIS_T_NEW_TRG_log02.dat", size = "2G" |
| CREATE DATABASE MIS_E_NEW_TRG ON MIS_E_NEW_TRG_data01 = '2G',MIS_T_NEW_TRG_data02='2G' log ON MIS_E_NEW_TRG_log01 = '2G',MIS_T_NEW_TRG_log02='2G' for load |
| |
CREATE DATABASE MIS_T ON MIS_T_data01 = '2G' log ON MIS_T_log01 = '2G' | disk init name = "MIS_T_TRG_data01", physname = "D:\sybase\data\MIS_T_TRG_data01.dat", size = "2G" |
ALTER DATABASE MIS_T ON MIS_T_data02 = '2G' log ON MIS_T_log02 = '2G' | disk init name = "MIS_T_TRG_log01", physname = "D:\sybase\data\MIS_T_TRG_log01.dat", size = "2G" |
ALTER DATABASE MIS_T ON MIS_T_data03 = '2G' log ON MIS_T_log03 = '2G' | CREATE DATABASE MIS_T_TRG ON MIS_T_TRG_data01 = '2G' log ON MIS_T_TRG_log01 = '2G' for load |
ALTER DATABASE MIS_T ON MIS_T_data04 = '2G' log ON MIS_T_log04 = '2G' | |
ALTER DATABASE MIS_T ON MIS_T_data05 = '2G' | |
ALTER DATABASE MIS_T ON MIS_T_data06 = '2G' | |
| |
LOAD DATABASE MIS_T from "compress::D:\backup\20111210\MIS_T_20111210060114.dmp.gz" | |
</code> | </code> |
| |
待續 | 待續 |