SQL数据库自动备份 [英] SQL Database automatic back up
问题描述
我有一个SQL数据库-我需要每天(至少)备份一次-最好每天备份几次-自动备份，这样肯定可以完成.
I have an SQL database - I need to back it up everyday (at a minimum) - preferably multiple times a day - automatically so it definitely gets done.
我正在运行存储SQL数据库的Windows.
I'm running Windows which the SQL database is stored on.
我可以使用哪些程序(最好是免费的程序)来备份它-我是SQL的新手，所以如果您要解释一下-用外行的话做，谢谢(:
What programs (prefer free ones) can I use to back it up - I'm completely new with SQL so if you're gonna explain something - do it in layman's terms thanks (:
它需要备份到另一台服务器(在LAN上).
It needs to get backed up to another server (on the LAN).
推荐答案
使用维护计划自动备份数据库
Auto Backup Database Using Maintenance Plans
简单步骤:
-
转到SQL Server配置管理器> SQL Server服务>运行SQL Server代理(将其设置为自动运行)
Go To SQL Server Configuration Manager > SQL Server Services > Run SQL Server Agent (Set it to Run Automatically)
转到SQL Server Management Studio，找到"TAB管理">维护计划".右键单击>维护计划向导.
Go To SQL Server Management Studio, Find TAB Management > Maintenance Plans. Right Click > Maintenance Plans Wizard.
输入维护计划的文本，例如:DailyBackup.选择选项"按钮:完成整个任务的单一计划.
Text your maintenance plans, ex: DailyBackup. Select Option button : Single Schedule for entire task.
根据需要单击配置">设置时间表".
Click Configure > Set Schedule according your demands.
选择维护任务.对于这种情况，请选择完全数据库备份".
Select Maintenance tasks. for this case, you choose Full Database backup.
单击下一步"，然后定义要备份的数据库，设置备份位置和备份扩展名.
Click Next, then define which database to backup, set backup location, and backup extension.
这篇关于SQL数据库自动备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
