Translate this Page

 

In SQL Server, every transaction (Insert, Delete, Update, etc) will put in Transaction Log File. This file need for recovery. That’s why, before we purge transaction log, we should doing Full Backup of the database first.

  • Check the Free Space of the vCenter Server

Check Free Space

Continue reading »

 

Berikut adalah cara setting Connection SQL Server to Oracle :

  • Install Oracle Client di SQL Server Machine
  • Modify regedit, file dll yang digunakan tergantung versi oraclenya. Disini saya menggunakan Oracle 10g :

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]

            - “OracleXaLib”=”oraclient10.dll”

            - “OracleSqlLib”=”orasql10.dll” 

            - “OracleOciLib”=”oci.dll

  • Restart Server dimana SQL  Server terinstall
  • Create Connection to Oracle Server using ODBC, Continue reading »
© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha