Bagaimana Kami Bisa Membantu?
Potong Database
Matikan semua Program/Aplikasi yang berhubugan dengan database.
Sebelum melakukan potong database, lakukan backup database terlebih dahulu.
lihat cara backup database disini.
Setelah selesai melakukan backup database, kita lanjutkan dengan potong database.
Berikut contoh untuk menyisakan data 7 hari pada database
Klik kanan pada database otomax lalu pilih New Query
Pada Halaman Query masukan script dibawah ini:
DELETE inbox WHERE (tgl_status<getdate()-7 and is_jawaban=1) or (tgl_status<getdate()-7 and is_jawaban=0)
DELETE outbox WHERE tgl_status<getdate()-7
DELETE transaksi WHERE tgl_entri<getdate()-7
DELETE mutasi WHERE tanggal<getdate()-7
DELETE FROM sistem_log WHERE waktu<getdate()-7
DELETE FROM komisi WHERE kode_transaksi <=(select top 1 kode from transaksi (nolock) where tgl_entri>=getdate()-7 order by kode desc) and tukar=1
DELETE outbox WHERE tgl_status<getdate()-7
DELETE transaksi WHERE tgl_entri<getdate()-7
DELETE mutasi WHERE tanggal<getdate()-7
DELETE FROM sistem_log WHERE waktu<getdate()-7
DELETE FROM komisi WHERE kode_transaksi <=(select top 1 kode from transaksi (nolock) where tgl_entri>=getdate()-7 order by kode desc) and tukar=1
Script diatas harus di execute per baris

Lamanya proses tergantung seberapa besar ukuran database.
Jika berhasil akan muncul tampilan seperti ini
Setelah selesai melakukan potong database, hal yang lain yang perlu dilakukan antara lain:
– Reindex database, Menyusun ulang/merapihkan susunan database. Petunjuk reindex Klik disini.
– Shrink Database, Mengecilkan ukuran file database. Petunjuk Shrink Klik disini.HOW TO CUT DATABASE
Turn off all Programs / Applications that are related to the database.
Before cutting the database, do a database backup first.
see how to backup the database here.
After completing the database backup, we continue to cut the database.
The following is an example of leaving 7 days of data in the database.
Right-click on the Auto Database then select New Query

On the Query Page, enter the script below:
DELETE inbox WHERE (tgl_status<getdate()-7 and is_jawaban=1) or (tgl_status<getdate()-7 and is_jawaban=0)
DELETE outbox WHERE tgl_status<getdate()-7
DELETE transaksi WHERE tgl_entri<getdate()-7
DELETE mutasi WHERE tanggal<getdate()-7
DELETE FROM sistem_log WHERE waktu<getdate()-7
DELETE FROM komisi WHERE kode_transaksi <=(select top 1 kode from transaksi (nolock) where tgl_entri>=getdate()-7 order by kode desc) and tukar=1
The script above must be executed per line

The duration of the process depends on the size of the database.
If successful, a display like this will appear

After finishing cutting the database, other things that need to be done include:
– Reindex, Reorder / arrange the database structure. How to reindex Click here.
– Shrink Database, Minimizes the size of the database file. How to shrink Click here.
DELETE outbox WHERE tgl_status<getdate()-7
DELETE transaksi WHERE tgl_entri<getdate()-7
DELETE mutasi WHERE tanggal<getdate()-7
DELETE FROM sistem_log WHERE waktu<getdate()-7
DELETE FROM komisi WHERE kode_transaksi <=(select top 1 kode from transaksi (nolock) where tgl_entri>=getdate()-7 order by kode desc) and tukar=1
OtomaX – Orisinil Topup Machine Fully automatic mobile prepaid recharge software