Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can i take back up of SQL db from VB?

Status
Not open for further replies.
Som76

Som76

Programmer
Jun 25, 2003
50
IN
Please can any one help:
1. How can i take back up of SQL db from VB?
2. How can i restore the db again?

Thanks
Som
 
Sort by date Sort by votes
Som,

You have to use below objects to backup and restore the SQL Server DB these are:

SQLDMO.SQLServer
SQLDMO.Backup

Thanks
Mansoor



 
Upvote 0 Downvote
Thanx Mansoor.

I tried using SQLDMO.
Can u tell me any other ways as well?

Thanx again.
Som
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
401
Andrzejek
Andrzejek
Ken01
  • Question
VB classic graphics 1
Replies
1
Views
226
strongm
strongm
sal21
  • Locked
  • Question
via vb 6.0, please split access table
Replies
1
Views
388
strongm
strongm
sal21
  • Locked
  • Question
DOWNLOAD story of extraction of LOTTO 1
Replies
4
Views
567
strongm
strongm
sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
847
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top