差異處

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

連向這個比對檢視

Both sides previous revision 前次修改
sybase:move [2011/12/13 03:37]
jal
sybase: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
  
-CREATE DATABASE MIS_T ON MIS_T_data01 ​'2G' log ON MIS_T_log01 ​'2G' +disk init name "​MIS_T_NEW_TRG_data01",​ physname = "​D:​\sybase\data\MIS_T_NEW_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_NEW_TRG_data02",​ physname = "​D:​\sybase\data\MIS_T_NEW_TRG_data02.dat",​ size = "2G" 
-ALTER DATABASE ​MIS_T ON MIS_T_data03 ​= '​2G' ​log ON MIS_T_log03 ​= '​2G'​ +disk init name "​MIS_T_NEW_TRG_log01",​ physname = "​D:​\sybase\data\MIS_T_NEW_TRG_log01.dat",​ size = "2G
-ALTER DATABASE MIS_T ON MIS_T_data04 ​= '​2G' ​log ON MIS_T_log04 ​= '​2G'​ +disk init name "​MIS_T_NEW_TRG_log02",​ physname = "​D:​\sybase\data\MIS_T_NEW_TRG_log02.dat",​ size = "2G" 
-ALTER DATABASE ​MIS_T ON MIS_T_data05 ​= '​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 
-ALTER DATABASE MIS_T ON MIS_T_data06 ​= '​2G'​+ 
 +disk init name = "​MIS_T_TRG_data01",​ physname = "​D:​\sybase\data\MIS_T_TRG_data01.dat",​ size = "​2G"​ 
 +disk init name = "​MIS_T_TRG_log01",​ physname = "​D:​\sybase\data\MIS_T_TRG_log01.dat",​ size = "​2G"​ 
 +CREATE ​DATABASE ​MIS_T_TRG ​ON MIS_T_TRG_data01 ​= '​2G' ​log ON MIS_T_TRG_log01 ​= '​2G' ​for load
  
-LOAD DATABASE MIS_T from "​D:​\backup\20111210\MIS_T_20111210060114.dmp"​ 
 </​code>​ </​code>​
  
 待續 待續