简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

SQL SERVER定时备份数据库两种方法

WBOY
Release： 2016-06-07 17:49:36
Original
1598 people have browsed it

今天我们来总结两种关于SQL SERVER定时备份数据库方法，有需要对SQL SERVER定时备份数据的朋友可参考本教程。

维护计划

1，新建维护计划，命名'DB_Bak'，并从工具栏选择‘备份数据库’任务，

2，属性页面，选择数据库，过期时间，和备份目录，这里我选择了网络存储器上的一个分区，提高容灾能力，当然你备份在本地目录也可以

3，保存后，就可以在'SQL代理'中的'作业'看到,一项新建的'DB_Bak.subpan_1'的作业了，它是按你的维护计划的名字命名的，所有很容易找到

4，点作业右键'属性'弹开详细设置，选择左侧'计划',新建-名称-执行(每天/每周/每月自选)-执行时间-持续时间

5,确定再确定就完成


方法二利用命令模式

点击 "管理"--"sql server代理"--"作业"

新建作业：

常规选项卡里,"名称"填写"定时备份数据库"，"启用"前面选"对勾"，"以本地服务器为目标"，

 "分类"选择"数据库服务"，

步骤选项卡里，新建步骤，步骤名：备份数据库；类型：Transact-SQL脚本(TSQL);

 数据库：要备份的数据库；

 命令：

 代码如下 复制代码

declare @filename varchar (1000)

set @filename='E:数据库备份book'+convert(char(10),getdate(),112)

print @filename
Related labels：
Regular backup database
source：php.cn
Previous article：MySQL中文排序错误的解决方法 Next article：mysql distinct 多列问题结合group by的解决方法
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Select woocommerce related products using custom taxonomy with 3 level hierarchy I have a woocommerce store with a custom classification of "Sports". The classif...
From 2024-04-06 20:05:30
0
1
544
Trouble getting specific statistics (Stats) from PokeAPI using Axios and Node.js I have a problem, I'm trying to use the PokemonAPI, but when I try to access the attack, H...
From 2024-04-06 18:46:35
0
1
464
Laravel 8 - How to redirect /{editable_text} route to /{user} route I've been trying to create a redirect route to lead me to a user profile. The redirect rou...
From 2024-04-06 17:26:11
0
1
410
React Three Fiber: Why are my scroll events lagging? In ReactThreeFiber, I have a React component that generates a sprite that I want to persis...
From 2024-04-06 13:39:24
0
1
410
vue vee-validate captures the problem of date picker selection The v-model binding on my datepicker field is not working properly. When you make a select...
From 2024-04-06 11:38:56
0
1
510
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！