Discussion Locked

How to take Backups on Click Button ?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

by david

There are three steps involved:
1. First create a job in SQL Server 7 to backup but don't set any schedule.
2. Create a stored procedure using sp_start_job
3. In VB client, call that procedure using command object within your program time settings.

by ktendulkar

In Job scheduling it doesnt allow us to select the table to be backed up on daily, weekly & monthly basis.
Please suggest us in detail

This discussion is closed to new replies.