数据库备份策略 [英] Database backup policy

问题描述

大家好，

预先感谢，

每3个月，我将备份全部数据，并在3个月前删除所有数据，以便仅保留当前3个月的数据.

问候，

Jeevan.

Hi all,

Thanks in advance,

For every 3 months I will take backup of the entire data and will delete all the data before 3 months so that only current 3 months data will be maintained.

Regards,

Jeevan.

推荐答案

您好，为此，您需要创建作业，这是您只能按照计划的时间进行数据库备份的唯一方法.为了缩短所有表，您需要创建一个存储过程，以便在执行备份后执行.
如果您想创建工作，请通过


此链接
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.asp [^ ]

Hi,For it u need to create job that is only way u would be able to take database backup as per ur scheduled time . and for truncating all the table u need to create a stored procedure to be execute after u take backup.
If u want to create job then go through


this link
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.asp[^]

为此，您必须创建一个作业

浏览以下链接，了解如何在sqlserver中处理Josbs

For this one You have to create a Job

Go through the below link for How to habdling Josbs in sqlserver
Jobs in sql server[^]

You have to maintain last 3 months data.., Don''t TRUNCATE the tables(as Wasif) said, this leads to a Data Loss.

Execute DELETE Quires in Job that delete only before 3 months data..,
At time of Job execution You have total 6 months data(if you are executing it for every 3 months)

这篇关于数据库备份策略的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！