Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 170 views

    Auto Backup SQL Server 2000

    Uploaded by

    Rikky Mahesa
    This help you to manage and backup your database on SQL Server 2000!!! Share this to other and don't forget to credit it! Comment and suggestions are welcome to fix in the future.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Auto Backup SQL Server 2000

    Uploaded by

    Rikky Mahesa
    170 views5 pages
    This help you to manage and backup your database on SQL Server 2000!!! Share this to other and don't forget to credit it! Comment and suggestions are welcome to fix in the future.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This help you to manage and backup your database on SQL Server 2000!!! Share this to other and don't forget to credit it! Comment and suggestions are welcome to fix in the future.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    170 views5 pages

    Auto Backup SQL Server 2000

    Uploaded by

    Rikky Mahesa
    This help you to manage and backup your database on SQL Server 2000!!! Share this to other and don't forget to credit it! Comment and suggestions are welcome to fix in the future.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    By: Luc1f3R

    1. Aktifkan service “SQL Server Agent”


    menjadi “Automatic”. Masuk ke run
    ketik “services.msc” cari service
    “SQLSERVERAGENT” lalu double klik di
    service tersebut dan ubah “Startup
    Type”-nya menjadi “Automatic” lalu OK
    dan close semua.

    2. Buka “Enterprise Manager” masuk ke “(local)>Mangement>Database Maintenance Plan” lalu klik


    kanan pilih “New Maintenance Plan”.

    Tutorial Auto Backup SQL Server 2000

    By : Luc1f3R
    3. Klik Next, lalu ceklis database mana yang akan di backup otomatis klik next, lalu next lagi, lalu next lagi
    sampai muncul “Specify the Database Backup Plan” lalu klik “Change”.

    Tutorial Auto Backup SQL Server 2000

    By : Luc1f3R
    4. Atur sesuai keinginan ingin berapa hari sekali, mingguan, atau bulanan dan tiap jam berapa sistem
    akan otomatis menjalankan backup.

    E G H I
    A
    B
    C F
    J K L

    i. Daily :
    A. Pilih untuk memilih backup harian.
    G. Pilih 1 untuk backup setiap 1 hari sekali mulai dari dibuatnya sistem, dst.

    ii. Weekly :
    B. Pilih untuk melakukan backup mingguan.
    E. Pilih untuk berapa minggu sekali sistem melakukan backup.
    F. Ceklis Sun(Sunday) agar sistem melakukan backup setiap hari minggu, dst.

    iii. Monthly :
    C. Pilih untuk melakukan backup bulanan.
    H. Pilih setiap tanggal berapa sistem backup.
    I. Pilih 1 untuk 1 bulan sekali, dst.
    J, K, L. Pilih 1st Sunday 1 month untuk backup setiap hari minggu pertama tiap bulannya.

    D. Ubah waktu sesuai yang dikehendaki, usahakan di jam-jam yang tidak terlalu padat lalu-lintas
    data dari Server-Client ataupun Client-Server. Klik OK lalu Next.

    Tutorial Auto Backup SQL Server 2000

    By : Luc1f3R
    5. Pilih “Use the default backup directory” untuk menyimpan backup di “%\Microsoft SQL
    Server\MSSQL\BACKUP” atau pilih “Use this directory” untuk menyimpan di partisi dan folder
    yang kita kehendaki, disarankan ceklis “Remove files older than:” dan di sesuaikan dengan
    settingan waktu di poin no 4 agar tidak terlalu membebani harddisk dan membuat harddisk
    penuh, ”Backup file extension” bisa dipilih apa saja sesuai keinginan.

    6. Terakhir Next terus sampai sebelum Finish ubahlah nama “Maintenance Plan” sesuai yang
    dikehendaki.

    Sekian, semoga bermanfaat, SILAHKAN copas ASAL cantumkan sumber.

    Tutorial Auto Backup SQL Server 2000

    By : Luc1f3R

    You might also like