设置SQL2005自动备份数据库
来源:互联网 发布:乐乎pt 被禁 编辑:程序博客网 时间:2024/05/16 12:27
How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005
INTRODUCTION
This article describes how to schedule a database backup operation by using SQL Server Management Studio in Microsoft SQL Server 2005.
MORE INFORMATION
To schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005, follow these steps:
- Start SQL Server Management Studio.
- In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list.
- Click Connect.
- In Object Explorer, expand Databases.
- Right-click the database that you want to back up, click Tasks, and then click Back Up.
- In the Back Up Database - DatabaseName dialog box, type the name of the backup set in the Name box, and then click Add under Destination.
- In the Select Backup Destination dialog box, type a path and a file name in theDestinations on disk box, and then click OK.
- In the Script list, click Script Action to Job.
- In the New Job dialog box, click Steps under Select a page, and then click Edit if you want to change the job parameters.
Note In the Job Step Properties - 1 dialog box, you can see the backup command. - Under Select a page, click Schedules, and then click New.
- In the New Job Schedule dialog box, type the job name in the Name box, specify the job schedule, and then click OK.
Note If you want to configure alerts or notifications, you can click Alerts orNotifications under Select a page. - Click OK two times.
You receive the following message:
原文链接:http://support.microsoft.com/kb/930615/en-us
- 设置SQL2005自动备份数据库
- sql2005自动备份数据库
- SQL2005自动备份数据库
- SQL2005 数据库自动备份
- SQL2005实现数据库自动备份
- SQL2005自动备份数据库[转]
- SQL2005自动备份数据库[转]
- SQL2005自动备份数据库,备份计划
- sql2005自动备份
- sql2005建立自动备份
- sql2005建立自动备份
- sql2005建立自动备份
- 实现SQL2005自动备份
- SQL2005 自动备份(英文)
- sql2005自动备份
- SQL2005自动定时备份数据库并按日期命名
- SQL2005恢复只有mdf文件的数据库 自动备份数据
- sql2005数据库远程备份
- 指定字符串的截取
- Spring2.5 注解介绍(3.0通用)
- 不同级目录文件的#include (转)
- Android锁屏与解屏相关代码分析
- imsi
- 设置SQL2005自动备份数据库
- 如何:在十六进制字符串与数值类型之间转换(C# 编程指南)
- WebLogic Server管理最佳实践
- android 系统开机运行指定程序
- Monthly
- linux的I2C驱动架构分析记录
- 关于矢量图中重画问题vc
- 如何 提高企业网站大数据量 效率
- 集群NAS技术架构 .