Database back UP

[hadinatayp]

I have a form and a button on it.

when i click the button itl will back-up my database.

does anybody know how to do it?

thx.

 

[kulrom]

what kind of database? Is that MSSQL database?

 

[hadinatayp]

SQL Server

 

[vis781]

Here's a link that may help......apologies for butting in kulrom.

http://www.aspfree.com/c/a/VB.NET/Simple-BackupRestore-Utility-With-SQLDMO-Using-VBNET/

 

[kulrom]

no problem Vis ... i didn't reply to this question intentionally. There are so many articles, tutorials etc. about this subject that i consider hadinatayp is sort of lazy to google for it. However, i hope your answer will help him.

Regards

 

[hadinatayp]

The articel that i read it use a user account to login to sql server :

OSqlServer.Connect("(local)\sqlexpress","user","password")

what should i put into to the function parameter, if i use the windows authentification to login to the sql?
I tried --> OSqlServer.Connect("(local)\sqlexpress") --> but it gave a an error message state login failed for user etc,etc