差異處

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

--- sybase:move [2011/12/12 18:28] – jal
+++ sybase:move [2011/12/13 03:37] – jal
@@ 行 20: / 行 20: @@
 <code>
+sp_configure "allow updates", 1
+bcp master..syslogins in D:\backup\20111210\syslogins_20111210_modify.txt -Usa -Ssybase -b 1 -c
+bcp master..syssrvroles in D:\backup\20111210\syssrvroles_20111210_modify.txt -Usa -Ssybase -b 1 -c
+bcp master..sysloginroles in D:\backup\20111210\sysloginroles_20111210.txt -Usa -Ssybase -b 1 -c
 update sysservers set srvnetname='SYBASE_BS' where srvid=1
@@ 行 35: / 行 41: @@
 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
+CREATE DATABASE MIS_T ON MIS_T_data01 = '2G' log ON MIS_T_log01 = '2G'
 ALTER DATABASE MIS_T ON MIS_T_data02 = '2G' log ON MIS_T_log02 = '2G'
 ALTER DATABASE MIS_T ON MIS_T_data03 = '2G' log ON MIS_T_log03 = '2G'
@@ 行 41: / 行 52: @@
 ALTER DATABASE MIS_T ON MIS_T_data06 = '2G'
-LOAD DATABASE MIS_T from "compress::D:\backup\20111210\MIS_T_20111210060114.dmp.gz"
+LOAD DATABASE MIS_T from "D:\backup\20111210\MIS_T_20111210060114.dmp"
 </code>
 待續