如何在SQL Server 2012中设置每周自动备份? [英] How to setup weekly auto backup in SQL Server 2012?

问题描述

请告知我如何在SQL Server 2012中设置自动数据库备份.

Please advice how can i setup automated database backup in my SQL Server 2012.

我需要将SQL Server中的所有数据库(当前仅包含3个数据库)进行一次自动每周备份，该备份在每个星期五的0100 h(凌晨1点)运行.这些备份文件(* .bak)应该放在E:\ Backups文件夹中.

I need to take all databases (currently it contains only 3 ) in SQL server an automated weekly backup which runs on Every Friday at 0100 h (1 AM). These back up files (*.bak) should be placed in E:\Backups folder.

推荐答案

在Microsoft SQL Server Management Studio中，打开Object Explorer，然后:

1. Management > Maintenance Plans
上的右斜线
2. New Maintenance Plan...
上的提示
3. 给您的计划起个名字
4. 根据策略需要创建任意多个子计划
5. 选择一个子计划，然后从Toolbox面板中拖放适当的任务
6. 要备份数据库，适当的任务是Back Up Database Task

1. Right-clic on Management > Maintenance Plans
2. Clic on New Maintenance Plan...
3. Give a name to your plan
4. Create as many subplans as you need for your strategy
5. Select a subplan and drag'n'drop the appropriate tasks from the Toolbox panel
6. To backup a database, the appropriate task is Back Up Database Task

对于备份计划的配置，您只需要遵循向导并定义所需的内容即可.如果您需要更多信息，我建议您访问Microsoft的官方网站: 创建完整的数据库备份

For the configuration of the backup schedule, you just need to follow the wizard and define what you want. If you need more information, i suggest you to go on the official website of Microsoft: Create a Full Database Backup

希望这对您有帮助

这篇关于如何在SQL Server 2012中设置每周自动备份?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！