Wah, nice script & Idea niy... Thanks Pak Robin, moga-moga dengan ini paranoia saya bisa berkurang :-)
Salam, Vavai --- In [email protected], "Robin Sembiring" <[EMAIL PROTECTED]> wrote: > Teknisnya mudah saja : > > 1. buat 1 script bat beri nama stop.bat dgn isi sbb : > @ECHO Stop Aktifitas Server > c:\mssql7\binn\isql -S (IP SERVER ANDA) -U sa -P "" -q > "Shutdown with nowait" > > 2. tambahkan script stop.bat pada Task Schedule Win Server anda. > (Atur maunya jam brpa di Stop SQL Servernya) > 3. buat 1 scrip bat lagi beri nama kopi.bat dgn isi sbb, ini hanya > contoh. > @ECHO Kopi Data Ke Q:\BACKUPSQL > > MKDIR Q:\BACKUPSQL\TEMP > copy c:\mssql7\data\Inventory_Data.MDF Q:\BACKUPSQL\TEMP > copy c:\mssql7\data\Inventory_log.lDF Q:\BACKUPSQL\TEMP > > @ECHO Kompress > C:\Progra~1\WinAce\Winace a -r -s Q:\BACKUPSQL\SQLDATA.ACE > Q:\BACKUPSQL\TEMP > > 4. tambahkan script kopi.bat pada Task Schedule Win Server anda. > (Atur maunya jam brpa di Kopi SQL Servernya dan lbh baik 2 menit setelah di > stop) > 5. buat 1 scrip bat lagi beri nama runserver.bat dgn isi sbb : > > @echo off > @echo Starting Server > C:\MSSQL7\Binn\sqlmangr.exe /n > > dgn catatan semua dilakukan di Server , dan file-2 tsb di letakkan > di folder C:\MSSQL7\BIN and jgn lupa Install WINACE pd Server. > > Semoga berhasil & bermanfaat > > Robin S > > > > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of deny fibrata > Sent: Tuesday, August 09, 2005 8:08 PM > To: [email protected] > Subject: Re: [Programmer-VB] SQL Problem > > > pak robin, untuk poin nomer lima : 5. Backup Otomatis ( yang di backup > fisik filenya (MDF,NDF,LDF) ke Hardisk yang lain.--> gimana teknis caranya? > > terima kasih > ----- Original Message ----- > From: Robin Sembiring > To: [email protected] > Sent: Thursday, August 11, 2005 12:10 AM > Subject: RE: [Programmer-VB] SQL Problem > > > Tips menjaga agar data anda aman. > > 1. Server kasi UPS + Stabilizer > 2. Schedule On/OFF Service Manager Otomatis > Ex : On jam 8 pagi .. OFF jam 7 malam > 3. Pasang AntiVirus di Server anda. > 4. AC yang cukup > 5. Backup Otomatis ( yang di backup fisik filenya (MDF,NDF,LDF) > ke Hardisk yang lain. > > > > > Salam, > Robin S > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of deny fibrata > Sent: Tuesday, August 09, 2005 7:30 PM > To: [email protected] > Subject: [Programmer-VB] SQL Problem > > > temans, saya bikin program VB + SQL Server 7.0 > Saat ini saya mengalami masalah, dimana komputer server untuk SQL nya > mati mendadak, sehingga pada saat dinyalakan kembali, data menjadi tidak > dikenali. begitupun kalau file MDF dan LDF saya pindah ke komputer lain, > file tersebut tidak bisa dikenali.. > Apakah temans ada trik atau tehnik, sehingga kalau komputer mati / > hang mendadak, file data SQL tidak crash? > > terima kasih, > Salam, > deny f > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > > > > ---------------------------------------------------------------------------- > YAHOO! GROUPS LINKS > > a.. Visit your group "Programmer-VB" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service. > > > ---------------------------------------------------------------------------- ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h8ifisk/M=362131.6882499.7825260.1510227/D=groups/S=1705115364:TM/Y=YAHOO/EXP=1123652304/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] 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/
