How to make a backup from vb.net

[Stan Sainte-Rose]

Hi,
I would like to add a backup function in my winform app.
I use MSDE.
My idea was to :
Detach the database
Copy the mdf and ldf file to the destination support
Attach the database

But I don't know how to detach and attach the database from vb.net
Any idea ?

Stan

 

[Guest]

try "Microsoft SQLDMO Object Library" using this database can be backed up

 

[William Ryan eMVP]

sp_Attachdb and detach are the SQL Commands you'd execute against the db.