如何在SQL Server 2012中设置每周自动备份?

本文介绍了如何在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，然后:

Management > Maintenance Plans

上的右斜线

New Maintenance Plan...

上的提示

给您的计划起个名字

根据策略需要创建任意多个子计划

选择一个子计划，然后从Toolbox面板中拖放适当的任务

要备份数据库，适当的任务是Back Up Database Task

Right-clic on Management > Maintenance Plans

Clic on New Maintenance Plan...

Give a name to your plan

Create as many subplans as you need for your strategy

Select a subplan and drag'n'drop the appropriate tasks from the Toolbox panel

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

希望这对您有帮助