安排每日SQL 2008 R2备份的最佳方法是什么? [英] What is the best way to schedule daily SQL 2008 R2 backups

问题描述

在Express Edition中安排每日SQL 2008 R2备份的最佳方法是什么.
我该怎么办.

谢谢

What is the best way to schedule daily SQL 2008 R2 backups in express edition.
How can I do this.

Thanks

推荐答案

如果表达式版本允许您运行作业，那可能是最好的方法.

If the expression edition allows you to run jobs, that might be the best approach.

选择计划可能很有用，根据您的计划，您可以安排备份

增量备份-备份自上次增量备份以来的所有更改，因此，完全备份后的第一天将包括当天的更改.第二天的增量将仅包括当天的更改.


差异备份-备份自上次完整备份以来的所有更改.完整备份后的第二天将包括当天的更改.完全备份后第二天的差异备份将包括完全备份后第一天和第二天的更改.
完全备份-备份关键文件集中的所有文件


现场存储-磁带的现场存储应与系统保持足够的距离，这样，如果系统在意外中被破坏，备份副本将不会遭受同样的命运.防火保险箱通常是个不错的选择.


异地—磁带的异地存储应在单独的物理位置(不同的办公大楼，保管箱，家庭存储等).

http://www.imation.com/smb/tips_backup_plans.html [

It''s probabaly usefull to choose a plan, based on your plan you can schedule your back-ups

Incremental Backup — backup of all changes since last incremental backup, therefore, the first day follow your full backup will include the changes for that day. The second day’s incremental would only include changes that day.


Differential Backup — backup of all changes since last full backup. The day following the full backup would include changes that day. The differential backup for the second day following a full backup would include the changes the first day and the second day since the full backup.
Full Backup — backup of all files in your critical file set


On-site storage — Onsite storage of tapes should be far enough away from your system so that if you system is destroyed in an accident, your backup copy will not suffer the same fate. Fireproof safes are often a good option.


Off-site — Off-site storage of tapes should be a separate physical location (different office building, safe-deposit box, home storage, etc.).

http://www.imation.com/smb/tips_backup_plans.html[^]

由于SQL Server Express没有SQL服务器代理.

我们创建了一个存储过程，并使用Perl脚本根据Windows计划的任务执行该过程.

另一种方法是将PowerShell再次作为Windows计划任务.

Since SQL Server Express does not have SQL Server Agent.

We created a stored procedure and used a Perl script to execute it based on a windows scheduled task.

Another way would be PowerShell again as a windows scheduled task.

这篇关于安排每日SQL 2008 R2备份的最佳方法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！