Have you looked at the SQL Maintenance Wizard?
-Mike
>Hello,
>
>I need to implement some type of backup procedure and I need it to run on a schedule. I also need a way to initiate the backup to begin at some instances....
>
>Are there any SQL utilities provided with SQL2000 that would allows me to do this?
>
>I would prefer to use a stored procedure to accomplish this but if there is an easier way.... Please let me know..
>
>Thanks in advance..
>
>Alvin