当前位置:网站首页>[Database] How does Sqlserver backup the database regularly and clear it regularly
[Database] How does Sqlserver backup the database regularly and clear it regularly
2022-08-09 15:33:00 【getting warmer】
How to use the execution plan to back up the sqlserver database regularly and set the validity period to clear it?
Steps
Right click maintenance plan

Select whole plan or no plan, click change
Select the frequency of execution, then click OK
Check the task, then click Next
Next, select backup database
Select report
Question
SQLServerAgent is not currently running so it cannot be notified of this action 22022
Solution:
After confirming the problem, remote to the server.Follow these steps 1. Open Computer Management -> Services -> Find SQLSERVERAGENT Agent -> Start 
Find the service right click to start directly
边栏推荐
- Shell course summary
- 小程序制作软件哪个好用?如何选择?
- table中 You may have an infinite update loop in a component render function问题解决
- * 3-3 cattle from rearranged
- 论文笔记CIRS
- SQL Server查询优化
- 小程序模板制作流程,小程序模板制作方便快捷
- What is the cost of small program development and production?Three development methods cost analysis!
- my creative day
- RHCE Course Summary
猜你喜欢

Recursive implementation of the Tower of Hanoi problem

Which applet making software is easy to use?how to choose?

spacedesk-笔记本、平板、扩展屏幕-解决平板字体太小的问题

RHCE课程总结

Meta 发布 1750 亿聊天机器人,亿万富翁老板小扎被「他」疯狂吐槽!

Add-apt-repository command details

*3-1 CCF 2014-09-1 Adjacent pairs

论文笔记CIRS

猴蝎美人

*2-3 Upgraded version of OJ 1164 missile interceptor
随机推荐
[manjaro]更新后内核文件加载失败
论文笔记CIRS
leetcode 剑指 Offer 17. 打印从1到最大的n位数
青蛙跳台阶
【DevOps】jekinsBuild step ‘Execute shell‘ marked build as failure
Detailed firewall firewall
升级适配AGP 7.0
Shell course summary
拒绝“重复造轮子”,百度EasyDL让你玩转AI定制开发
SwiftUI 导航教程之如何实现没有 Navigation View的 SwiftUI 导航功能
在Word中如何调整编号和文字之间的间距?
Introduction to JUC Containers
同事的接口文档我每次看着就头大,毛病是真的多多多。。。
宁夏等保测评机构有哪些?如何选择?
The rising star DPU is revolutionizing the data center!
[manjaro] updated kernel file loading failure
firewall防火墙详解
VMWare不使用简易安装,手动安装ISO操作手册
IK学习笔记(1)——CCD IK
*3-1 CCF 2014-09-1 Adjacent pairs