HI Everyone,

I have designing a desktop application with SQL SERVER 2005. I have one form where user can take a full backup of SQL Database in one File. I have following controls :

1. txtSQLServerName
2. txtSQLDBName
3. txtSQLSQUserID
4. txtSQLSAPassword
5. txtBackupLocation
6. btnStart
7. btnCancel

When user process the backup, it should take a backup in specified location. The backup file should be like "BKP_F_YYYYMMDDHHMMSEC" e.g. "BKP_F_20100406131523.BAK" (where 2010 = Year, 04 = Month, 06 = Date, 13 = HOur, 15 = Minute, 23 = Second). When user process a backup on next day the backup file name should be same as the above with the different date and time. And i want this backup should be encrypted with password so that other person cannot restore my database.

DOES ANYONE HAS A IDEA HOW TO DO SO..?

TashiDuks

>The link was on C# language, and i am looking for VB language.

Both these languages uses the same framework. (The .NET Framework)

>The link was on C# language, and i am looking for VB language.

Both these languages uses the same framework. (The .NET Framework)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.