差異處

這裏顯示兩個版本的差異處。

連向這個比對檢視

兩邊的前次修訂版前次修改
下次修改
前次修改
sybase:move [2011/12/13 03:37] jalsybase:move [2011/12/13 03:43] (目前版本) jal
行 27: 行 27:
  
 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"
行 40: 行 38:
 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
  
-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+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>
  
 待續 待續
sybase/move.txt · 上一次變更: 2011/12/13 03:43 由 jal
上一頁 | 下一頁 | 回首頁 | RSS Feed | Facebook