• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

vb6 backup sql server

Hi, i am looking for possibly a 3rd party component that i can plug into or call from our vb6 app that can help with backing up a sql database. I am currently using the OSQL.exe option, butwould like to porvide an interface in my app to show available servers and then allow for a user to selectthe databases to backup ect.

thanks
0
CraigLazar
Asked:
CraigLazar
  • 2
2 Solutions
 
VBClassicGuyCommented:
This link introduces a method to do what you want:
http://www.dreamincode.net/forums/showtopic35361.htm 
 and this one gives you examples:
 http://www.sqldev.net/sqldmo/SamplesVB6.htm
0
 
PJBXCommented:
More than likely, you will have to use SQLDMO, here's another method:

http://pscode.com/vb/scripts/ShowCode.asp?txtCodeId=47433&lngWId=1
0
 
CraigLazarAuthor Commented:
Hi Guys,
 
sorry for getting back to this question so late, but will be back from leave in mid jan
thanks
0
 
CraigLazarAuthor Commented:
thanks allot for the links
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now