Kalo mau sekedar ditiban, tetep bisa pake database maintenance plan, tapi jangan backup ke "Device" ... pilih backup ke file... lalu pilih metodenya "overwrite" ... (padahal defaultnya append).
Di perush sya, SQL server di backup setiap jam 12 ke directory X:\SQLBackups dengan menggunakan file yang selalu di "overwrite" mode ... jam 3 pagi, webserver, mail server dan X:\SQLBackups di backup ke tape pake veritas ... nanti jam 10 pagi, petugas dari "off site data center" membawa disc tersebut dan menggantikan dgn disk yang laen untuk hari ganjil / genap ... dan seterusnya ... Rgds, Ardi. _____ From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 8:33 AM To: [email protected] Subject: Re: [ITCENTER] BACKUP SQL hmm, kenapa ditiban mas? kalo ditiban, bukan backup dong namanya? tapi kalo maunya mas sugi untuk niban, saya belom coba, cuma AFAIK, MS SQL kayanya tidak bisa (CMIIW). Semoga bisa membantu. Denis [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
