
Using this code You can easily backup your sql database. There were some code here that used ADO for the backup purpose, here in my code i have used the SQLDMO object for all the sql transactions.
Few code are taken from here and are upgraded with comments.
Hope you all would like the work