差異處

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

連向這個比對檢視

下次修改
前次修改
最後一次修改 兩邊的下次修訂版
sybase:move [2011/12/12 17:34] – 建立 jalsybase:move [2011/12/13 03:37] jal
行 5: 行 5:
 安裝過程不贅述,但是記得確認下列資訊 安裝過程不贅述,但是記得確認下列資訊
   - page size 如果沒有要升級,記得設定為一樣   - page size 如果沒有要升級,記得設定為一樣
-  - +
 <code> <code>
 isql -Usa -SSybaseServer -w1000 -e -n isql -Usa -SSybaseServer -w1000 -e -n
行 19: 行 19:
   - master.sysusages   - master.sysusages
  
 +<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
 +
 +
 +
 +disk init name = "MIS_T_data01", physname = "D:\sybase\data\MIS_T_data01.dat", size = "2G"
 +disk init name = "MIS_T_data02", physname = "D:\sybase\data\MIS_T_data02.dat", size = "2G"
 +disk init name = "MIS_T_data03", physname = "D:\sybase\data\MIS_T_data03.dat", size = "2G"
 +disk init name = "MIS_T_data04", physname = "D:\sybase\data\MIS_T_data04.dat", size = "2G"
 +disk init name = "MIS_T_data05", physname = "D:\sybase\data\MIS_T_data05.dat", size = "2G"
 +disk init name = "MIS_T_data06", physname = "D:\sybase\data\MIS_T_data06.dat", size = "2G"
 +disk init name = "MIS_T_log01", physname = "D:\sybase\data\MIS_T_log01.dat", size = "2G"
 +disk init name = "MIS_T_log02", physname = "D:\sybase\data\MIS_T_log02.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"
 +
 +
 +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'
 +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 "D:\backup\20111210\MIS_T_20111210060114.dmp"
 +</code>
  
 待續 待續
sybase/move.txt · 上一次變更: 2011/12/13 03:43 由 jal
上一頁 | 下一頁 | 回首頁 | RSS Feed | Facebook