SQL Server 2008中的差异备份 [英] Differential Backup in sql server 2008

问题描述

如何每隔3小时在sql 2008中进行差异备份

how to take differential backup in sql 2008 after every 3 hrs

推荐答案

看看
SQL Server的差异数据库备份 [创建SQL Server数据库的完整备份和差异备份 [

have a look at
Differential Database Backups for SQL Server[^]
or Creating Full and Differential Backups of a SQL Server Database[^]

http://msdn.microsoft.com/en-us/library/ms175526.aspx [ ^ ]

从您的疑问中，我还将介绍一下日志备份: http://msdn.microsoft .com/en-us/library/ms162133.aspx [ ^ ].

例如，差异之一是，使用日志备份时，您在上次锁定备份之后而不是上次完整数据库备份之后备份更改.

From the sound of your question I would also have a look at the log backups: http://msdn.microsoft.com/en-us/library/ms162133.aspx[^].

One of the differences is for example, that with log backups you backup the changes after the last lock backup instead of the last full database backup.

这篇关于SQL Server 2008中的差异备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！