Hello, Saya belum pernah pakai procedure backup seperti itu, tapi untuk share info saja... kita backup SQL Server data+log file dengan cara yg paling konvensional.... engine di stop, trus data+log file tinggal di copy + zip, untuk restore kita pake langkah kebalikannya...
ini efektif untuk data <100MB (masalah waktu copy+zip-nya)... trus bisa kita schedule proses itu malam2, jadi tidak terganggu users. restorenya gampang dan utuh... thanks, Alfonsus ----- Original Message ----- From: "renaldy_r" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, December 08, 2005 12:45 PM Subject: [binusnet] Restore Database > > temen2 , mohon bantuannya, gimana restore database differential backup > sql server 2000 dgn mengggunakan cara restore FROM DEVICE .. > > tiap kali saya restore kena msg error seperti ini : > > 4306 : The preceding restore operation did not specify WITH NORECOVERY > or WITH STANDBY. Restart the restore sequence, specifying WITH > NORECOVERY or WITH STANDBY for all but the final step. > > thx before.. > > > > > > > *._.**._.**._.**._.**._.**._.**._.**._.**._.**._.**._* > > ----^---------------------------------------------------- > Belajar Internet Marketing sekarang juga > dari Sekolah Internet Marketing yang pertama di Indonesia > Kesempatan Emas Dapatkan Modul Pertama > "Internet Marketing Basic" secara cuma-cuma, > hanya untuk 50 orang pengunjung pertama > http://www.AsianBrain.com/index.php?aff_code=503499 > ----------------------------------------------------------- > > BinusNet founded on Dec 28, 1998 > > Stop or Unsubscribe: send blank email to > [EMAIL PROTECTED] > Questions or Suggestions, send e-mail to [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > Send instant messages to your online friends http://au.messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/wf.olB/TM --------------------------------------------------------------------~-> *._.**._.**._.**._.**._.**._.**._.**._.**._.**._.**._* ----^---------------------------------------------------- Belajar Internet Marketing sekarang juga dari Sekolah Internet Marketing yang pertama di Indonesia Kesempatan Emas Dapatkan Modul Pertama "Internet Marketing Basic" secara cuma-cuma, hanya untuk 50 orang pengunjung pertama http://www.AsianBrain.com/index.php?aff_code=503499 ----------------------------------------------------------- BinusNet founded on Dec 28, 1998 Stop or Unsubscribe: send blank email to [EMAIL PROTECTED] Questions or Suggestions, send e-mail to [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/binusnet/ <*> 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/
