How to take Backups on Click Button ?

With Backend MS SQL 7.0, front end Visual Basic 6.0. From my front end on a click event of Button I have to take Backup of a particular tablefrom database on daily, weekly, monthly & yearly basis on a backup device like zip drive.