coba bantu yach...
backup di ms sqlserver ada 3
1. Full backup : Backup semua database (data +
transaksi)
2. differential backup : Hanya melakukan backup datanya aja
3. transaction log backup : Hanya melakukan backup
transaksinya aja (insert,update,delete) atau perubahan yang telah
dilakukan, tanpa membackup datanya.
FUll backup dilakukan terlebih dulu, dilanjutkan dengan differential
backup kemudian transaction log backup. kelebihan dari backup ini
adalah lebih cepat dan ukuran filenya yg relatif kecil dibandingkan
dengan selalu menggunakan full backup.
kelemahannya adalah pada saat restore.jika akan merestore
transaction log,maka akan dilakukan 3 kali restore yaitu restore
full backup, restore differential backup baru restore transaction
log backup.
ketiga backup ini akan membentuk tree sesuai dengan levelnya.
- Full Backup
- Differential Backup
- Transaction log Backup
Semoga Membantu.
nb: Buat The Doctor
untuk ADO, boleh dong japri n tnx
Best Regards
Azam
--- In [email protected], Padu Arsana W <[EMAIL PROTECTED]>
wrote:
>
> kalo saya gak salah ngerti ni:
>
> differential backup >> memback-up file2 yg mengalami perubahan
setelah backup terakhir
> transaction log backup >> membackup file2 log database
>
> bingung gak ?? ok untuk lebih jelasnya mending langsung
kesini ::
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/architec/8_ar_aa_1syt.asp
>
>
> pasti lebih jelas
> salam,
> Wayan
>
>
>
>
> Santosa <[EMAIL PROTECTED]> wrote:
> Hi
>
> Saya mau tanya tentang backup database di ms sql
> server.
> Apakah beda differential backup dan transaction log
> backup ?
>
> Kalau dilihat dari proses restore-nya,
> restore dari full backup + diffrential backup
> restore dari full backup + transaction log backup,
> apakah hasilnya sama ?
>
> terima kasih sebelumnya
> santosa
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> Wahana Programmer Groups Links
>
>
>
>
>
>
>
> SPONSORED LINKS
> Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java
programming language
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "Programmer-VB" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> ---------------------------------
>
>
>
>
>
> Matur suksma,
>
> Padu Arsana W
> Penida Island, Klungkung - Bali
>
> ---------------------------------
> Yahoo! Mail
> Use Photomail to share photos without annoying attachments.
>
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
