Backup menjadi bagian penting dalam setiap sistem, termasuk database sebagai tulang punggung media pengolahan dan penyimpanan data, namun pekerjaan rutin dalam melakukan backup database yang terlihat sederhana tapi cukup menyita waktu bagi pelaksananya.
Bagi anda para pengguna sistem operasi Windows mungkin dapat memanfaatkan task scheduler untuk menjalankan perintah backup dengan mengatur waktu yang diinginkan seperti tampilan berikut :
Nah beruntung bagi para pengguna SQL Anywhere, backup database tidak perlu lagi dijalankan secara manual atau menggunakan tools diluar database, cukup dengan memanfaatkan fitur EVENT dari SQLAnywhere yang sudah tersedia sejak versi jadul (di toko sebelah mana ada).
Dapat dilihat bahwa Events merupakan bagian dari database yang dapat digunakan untuk mengatur schedule yang ingin dilakukan dan tidak terbatas pada backup saja, karena perintah yang digunakan adalah bahasa SQL.
Untuk membuat event baru lakukan dengan langkah-langkah berikut :
- klik kanan pada icon events lalu pilih NEW
- Kemudian isikan nama event
- Pilih jenis trigger pada event yang akan kita buat, terdiri dari tiga pilihan, yaitu Manual, Scheduled atau Conditional
kita pilih scheduled agar event tersebut dilakukan sesuai jadwal yang kita inginkan
- Beri nama schedule yang ingin kita buat
- Isikan time dan Date schedule tersebut
Contoh disini menunjukan event dimulai tanggal 6 sept 2022 dan dijalankan pada pukul 19:00
- Lalu atur recurrence nya, yaitu iterasi yang diinginkan
Contoh disini event akan di trigge pada setiap akhir bulan
- Pilih Enabled event tersebut
- Setelah finish anda akan mendapatkan template script untuk event seperti berikut
- Terakhir ketik script backup nya dengan perintah berikut ini
- Selesai, anda dapat mencoba menjalankan event tersebut secara manual dengan memanggil event tersebut.
Untuk opsi perintah lengkap nya dapat di lihat pada link berikut ya
demikian cara mengatur backup otomatis menggunakan events pada SQLAynwhere, semoga menambah pengetahuan dan manfaat untuk kita.
sql anywhere backup
what is a sql anywhere backup image
sql anywhere backup utility
sql anywhere backup mapped drive
populate mysql database from sql anywhere backup
sql anywhere backup to unc
sybase sql anywhere backup mapped drive
sql anywhere backup auto
sql automated backup
sql automated backup and restore
sql automatic backup
sql anywhere backup auto access
sql anywhere backup auto add
sql anywhere backup auto archive
sql anywhere backup auto apply
sql anywhere backup auto auth
sql anywhere backup auto attendant
sql anywhere backup auto attendant shoretel
sql anywhere backup auto and restore
auto sql backup
automate sql backup and restore
automate sql server backup and restore
automate sql backups
sql anywhere backup auto backup
sql anywhere backup auto backup to external drive
sql anywhere backup auto body
sql anywhere backup auto brokers
sql anywhere backup auto body shop
sql anywhere backup auto best practices
sql anywhere backup auto bo
sql anywhere backup auto config
sql anywhere backup auto complete
sql anywhere backup auto configure
sql anywhere backup auto create table
sql anywhere backup auto check
sql anywhere backup auto cameras
sql anywhere backup auto command line
how to automatically backup an access database
sql anywhere backup auto delete
sql anywhere backup auto delete files
sql anywhere backup auto delete database
sql anywhere backup auto delete data
sql anywhere backup auto delete old conversations
sql anywhere backup auto delete old emails
sql anywhere backup auto delete old messages
sql anywhere backup auto database
sql anywhere backup auto database directory
automate sql database backup
sql anywhere scheduled backup
how to auto backup sql database
automatic backup in sql server
how to set auto backup in sql server 2014 express
sql anywhere backup auto forward
sql anywhere backup auto format
sql anywhere backup auto file
sql anywhere backup auto failover
sql anywhere backup auto fill
sql anywhere backup auto finance
sql anywhere backup auto fixer
sql anywhere backup auto finance phone number
sql anywhere backup auto generated password
sql anywhere backup auto generated
sql anywhere backup auto group
sql anywhere backup auto glass
sql anywhere backup auto glass repair
sql anywhere autoincrement
sql anywhere backup auto hide
sql anywhere backup auto host
sql anywhere backup auto history
sql anywhere backup auto hibernate
sql anywhere backup auto hotkey
how to auto backup access database
sql anywhere backup auto increment
sql anywhere backup auto install
sql anywhere backup auto insert
sql anywhere backup auto increment id
sql anywhere backup auto insert password
sql anywhere backup auto insurance
sql anywhere backup auto insurance quotes
sql anywhere backup auto join
sql anywhere backup auto json
sql anywhere backup auto job
sql anywhere backup auto keyword
sql anywhere backup auto key
sql anywhere backup auto keystore
sql anywhere backup auto login
sql anywhere backup auto lock
sql anywhere backup auto log
sql anywhere backup auto loan calculator
sql anywhere backup auto loan
sql anywhere backup auto line
phpmyadmin automatic backup
sql anywhere backup auto migration
sql anywhere backup auto mode
sql anywhere backup auto merge
sql anywhere backup auto machine
sql anywhere backup auto move
sql anywhere backup auto mall
sql anywhere backup auto mart
sql anywhere backup auto museum
mssql automatic backup
ms access auto backup database
microsoft sql automatic backup
sql anywhere backup auto number
sql anywhere backup auto not working
sql anywhere backup auto network
sql anywhere backup auto note
sql anywhere backup auto near me
sql anywhere backup auto nation
sql anywhere backup auto overwrite
sql anywhere backup auto open
sql anywhere backup auto on
sql anywhere backup auto organize
sql anywhere backup auto outlet
sql anywhere backup auto owners insurance
sql anywhere backup auto owners login
sql anywhere backup auto password
sql anywhere backup auto populate
sql anywhere backup auto password change
sql anywhere backup auto parts
sql anywhere backup auto practices
sql anywhere backup auto query
sql anywhere backup auto queue
sql anywhere backup auto quote
sql anywhere backup auto quit
qnap auto backup
sql anywhere backup auto restart
sql anywhere backup auto run
sql anywhere backup auto restore
sql anywhere backup auto reboot
sql anywhere backup auto refresh
sql anywhere backup auto repair
sql anywhere backup auto reset
rds sql server automated backups
sql anywhere backup auto start
sql anywhere backup auto shutdown
sql anywhere backup auto save
sql anywhere backup auto scaling
sql anywhere backup auto startup
sql anywhere backup auto sales
sql anywhere backup auto salvage
sql anywhere backup auto script
sql anywhere backup auto start database
sql anywhere backup auto sap
sql anywhere backup auto trigger
sql anywhere backup auto type
sql anywhere backup auto tune
sql anywhere backup auto timeout
sql anywhere backup auto transaction
sql anywhere backup auto trader
sql anywhere backup auto transport
sql anywhere backup auto train
t-sql backup all databases
t-sql backup and restore database
t-sql backup table
sql anywhere backup auto update
sql anywhere backup auto upgrade
sql anywhere backup auto upholstery
sql anywhere backup auto utility
sql anywhere backup auto verify
sql anywhere backup auto validation
sql anywhere backup auto value
sql anywhere backup auto version
sql anywhere backup auto v cheat codes
sql anywhere backup auto veeam
sql anywhere backup auto write
sql anywhere backup auto warning
sql anywhere backup auto wake
sql anywhere backup auto windows
sql anywhere backup auto wrecking
sql anywhere backup auto world
sql anywhere backup auto wreckers
sql anywhere backup auto xml
sql anywhere backup auto x64
sql anywhere backup auto x86
sql express auto backup
sql database auto backup schedule
auto mysql backup
sql anywhere backup auto zero
sql anywhere backup auto zip
sql anywhere backup auto zoom
sql anywhere backup auto zip file
sql anywhere backup auto zone
sql anywhere backup auto 100
sql anywhere backup auto 12c
sql anywhere backup auto 17
sql anywhere backup auto 16
sql anywhere backup auto 2022
automate sql backup
sql anywhere backup auto 32 bit
sql anywhere backup auto 3.0
sql anywhere backup auto 32
sql anywhere backup auto 404
sql anywhere backup auto 403
sql anywhere backup auto 5000
sql anywhere backup auto 500
sql anywhere backup auto 5 cheats
sql anywhere backup auto 5 cheats ps4
sql anywhere backup auto 64 bit
sql anywhere backup auto 6.7
sql anywhere backup auto 6 release date
sql anywhere backup auto 8.1
sql anywhere backup auto 8.0
sql anywhere backup auto 8.5
sql anywhere backup auto 8.2
sql anywhere backup auto 9.0
sql anywhere backup auto 9.5
0 comments on “Mengatur Backup Otomatis pada SQLAnywhere” Add yours →