Balasan: Re: [Programmer-VB] Re: Backup Data SQL

Sun, 19 Mar 2006 23:33:07 -0800

Dear Mas Andi
 
Berarti database-nya lagi running, jadi jangan buka database yg lagi direstore,
atau lebih jelasnya lihat di SQL Enterprise Manager :
1. Pilih Database yg akan direstore
2. Pilih menu Management
3. Pilih Current Activiy ==> Process Info
Nah bila database yg akan direstore ternyata muncul disitu alias lagi dipake langsung aja KILL PROSES processid tsb lalu bisa kamu restore
cobalah barangkali bisa
 
Regards,
Eko Mojokerto Putra Tifosi

Andi Kusnadi <[EMAIL PROTECTED]> menulis:
Mas Rifa,
 
Pada saat saya restore muncul error dia bilang database in use, gimana yach ?
 


 
On 3/16/06, aris <[EMAIL PROTECTED]> wrote:
MASTER PROGRAMMER (e.. Hacker)  kayaknya udah insyaf nih! he..he.. 
----- Original Message -----
From: co_rifa
Sent: Thursday, March 16, 2006 3:44 PM
Subject: [Programmer-VB] Re: Backup Data SQL

 
rumus backup:

execute "BACKUP DATABASE [NamaDatabase] to disk='c:\NamaFile.bak'

rumus Restore:

execute "RESTORE DATABASE [NamaDatabase] FROM DISK='c:\NamaFile.bak'


semoga bermanfaat.


regards.



Rifa Hammet

Hacker's at #HackerLinks

--- In [email protected], "Andi Kusnadi"
<[EMAIL PROTECTED]> wrote:
>
> Dear Rekan2,
>
> Saya mau tanya nich gimana caranya Backup & Restore data
menggunakan VB
> dengan database SQL Server 2000, terima kasih
>







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




  •  To unsubscribe from this group, send an email to:
      [EMAIL PROTECTED]
     
  •  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
    •



      Apakah Anda Yahoo!?
      Kunjungi halaman depan Yahoo! Indonesia yang baru!

      Apakah Anda Yahoo!?
      Kunjungi halaman depan Yahoo! Indonesia yang baru!

      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



      SPONSORED LINKS
      Programmer Indonesia Basic programming language
      Computer programming languages Programming languages Java programming language

      YAHOO! GROUPS LINKS



      Kirim email ke