如何安排在SQL Server 2008中的备份? [英] how to schedule backup in sql server 2008?

问题描述

如何在SQL Server 2008中安排每天晚上9:00备份?

how can I schedule daily backup at 9:00pm in SQL server 2008?

推荐答案

1. 使用 Microsoft SQL Server Management Studio 创建新的维护计划.

1. Use Microsoft SQL Server Management Studio to create a new Maintenance Plan.

在对象资源管理器中，转到文件夹管理>维护计划.

In the object explorer go to the folder Management > Maintenance Plans.

这将打开设计器.

在工具箱中，您将找到一个名为备份数据库任务"的任务，将其拖到设计器中.

In the Toolbox you will find a task named Back Up Database Task, drag this onto the designer.

右键单击备份数据库任务"，从上下文菜单中选择编辑

Right click 'Back Up Database Task' select edit from the context menu

备份类型:

• 完整:每次(参考)
• 差异:备份上次状态和当前状态之间的更改.如果要还原，将需要所有差异+初始备份！ (参考)
• 事务日志:对自上次完整备份以来的事务进行备份. (参考)

• Full: Does a full backup each time (ref)
• Differential: Makes a backup of the changes between last and current state. You will need all differentials + initial backup if you want to restore! (ref)
• Transaction Log: Makes a backup of the transactions since last full backup. (ref)

右键单击该任务以选择要备份的数据库.

Right click the task to select the databases to backup.

更改维护计划的时间表以设置其运行时间.

Change the schedule of your maintenance plan to set when it will run.

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