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

Taking Automatic Backup Of sql server database

P: 7
Hi
I need to take automatic backup of my sqlserver2005 database per day.
And I don't want to replace old backup,a new backup should be made per
day.

Thanks in advance
Sep 18 '09 #1
Share this Question
Share on Google+
3 Replies


P: 7
U can do it through any application na? Or u want the SQl Server itself to take backup automatically?
Sep 26 '09 #2

P: 7
Yes I wanted SQL Server itself take backups automatically..
And i have successfully executed this task using a stored procedure
and running this procedure using windows scheduled task.

by the way Thanks for your reply..
Sep 26 '09 #3

100+
P: 254
Hi I also need to take the database backup so can you please show me your stored procedure
Nov 25 '09 #4

Post your reply

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