Backup SQL Server Database via Visual Basic Code

Do you know how to take backup of SQL Server using Batch file ?

Do you know how to take backup of SQL Server using Batch file ?

sorry i must say i havent gone thro' it. if u could explain i would be grateful.

Please find a related discussion here .

First create a batch file called backup.bat (It first deletes the existing
backup file, then make a call for the sql command);

c:
cd\backup
del samincbu.bak
sqlcmd -i c:\backup\backup.sql
Then create the T-SQL commands in the file backup.sql, as indicated in
the batch file;

EXEC sp_addumpdevice 'disk', 'samincbu',
'c:\Backup\samincbu.bak'
BACKUP database saminc TO samincbu
GO

Finally you need to call the batch file from VB using SHELL function.