如何每天下午1点恢复 [英] How to take back up in every day 1 pm

问题描述

你好，

您能告诉我是否有任何查询，如何在每天下午1点维护SQL备份.

Hello,

can you please tell me is there any query, how to maintain sql back up in every day 1 pm.

thanks in advance.

推荐答案

您可以创建备份作业，如详细显示 ^ ].

You can create a backup job as shown in detail here[^].

只需添加到Abhinav的解决方案中，以下更多链接将帮助您入门:
1. http://cherupally.blogspot.com/2009/04/schedule-daily-backup-for-sql-server_27.html [ http://www.red-gate.com/help/sqlbackup/topics/SBU_SchedulingBackups. html [ ^ ]
3. http://weblogs. asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx [ http://support.microsoft.com/kb/930615 [

Just to add to Abhinav''s solution, here are some more links which will get you started :
1. http://cherupally.blogspot.com/2009/04/schedule-daily-backup-for-sql-server_27.html[^]
2. http://www.red-gate.com/help/sqlbackup/topics/SBU_SchedulingBackups.html[^]
3. http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx[^]
4. http://support.microsoft.com/kb/930615[^]

Hope this helps.
All the best.

这篇关于如何每天下午1点恢复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！