By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,259 Members | 1,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,259 IT Pros & Developers. It's quick & easy.

Sql Backup

mafaisal
100+
P: 142
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
Feb 19 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
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
Feb 19 '08 #2

mafaisal
100+
P: 142
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
Feb 19 '08 #3

P: 4
why not just create a maintenance plan?? and schedule it to run when needed??
Feb 19 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.