how to create backup for database

[Kanan]

I am making on application using vb.net 2005 and sql server 2003. I have to make one page where after clicking a button the database that I have been using is to be backup to the path specified . How can I do that ? Can anybody tell me the code for solving this problem?

 

[madder69]

one way would be to retrieve the table collection from the sql database, then iterate through each table and write out xml to an xml writer object, save the xml to disk. thats good if its on a local network.

or try these:
Google searched