List Info

Thread: Sql Database backup through VB 6.




Sql Database backup through VB 6.
user name
2006-12-06 14:40:13
Hi Friends,
   
  I am using VB 6.0 and Sql Server 2000.
I want to take backup of Sql Server 2000 database through
VB.
How i can do this in vb, 
because client want to click on the Backup Menu in
Application
and take a backup at any time.
  
I was written a code in vb but its not worked,
         Backup Database DatabaseName To Disk = path with
backup name
   
  but its give me error that 
      'Cannot open backup device ' and path name
   
  Please guide me where i am wrong or give the correct
sysntax.
   
  Thank you in advance.
   
  With Regards,
   
  Chintan Shah
   
   

 				
---------------------------------
 Find out what India is talking about on  - Yahoo! Answers
India 
 Send FREE SMS to your friend's mobile from Yahoo! Messenger
Version 8. Get it NOW

[Non-text portions of this message have been removed]




'// =======================================================
    Rules : http://Reli
ableAnswers.com/List/Rules.asp
    Home  : http://groups.y
ahoo.com/group/vbHelp/
    =======================================================
    Post  : vbHelp@yahoogroups.com
    Join  : vbHelp-subscribe@yahoogroups.com
    Leave : vbHelp-unsubscribe@yahoogroups.com
'// =======================================================
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.y
ahoo.com/group/vbhelp/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://grou
ps.yahoo.com/group/vbhelp/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:vbhelp-digest@yahoogroups.com 
    mailto:vbhelp-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    vbhelp-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )