Sql Backup

[mafaisal]

Hello Experts

I am Using Sql2005 And Vb.net2005 . Hw to Back Up sqldatabase automatically in each day . It have any settings in sql or we written any code in front end for that PLZ

Faisal

[ck9663]

Try creating a stored proc that backup your database, put it in a job and schedule that job to run in a daily basis. Here's the syntax for the BACKUP.

-- CK

[mafaisal]

Hello

Thanx For Ur Reply

Faisal

Try creating a stored proc that backup your database, put it in a job and schedule that job to run in a daily basis. Here's the syntax for the BACKUP.

-- CK

[ricka49]

why not just create a maintenance plan?? and schedule it to run when needed??