这些“仅复制备份”选项是什么意思？ [英] What do these Copy Only Backup options mean?

问题描述

我目前正在尝试备份一个空的SQL Server 2008 R2数据库，该数据库是我为暂时搁置的项目设计的。当我发现有一个进行仅复制备份的选项时，我正在通过SQL Management Studio进行备份过程。我抬头看了看是什么，但我不完全了解我所获得的选择。

I am currently trying to backup an empty SQL Server 2008 R2 database that I designed for a project that is getting shelved for the time being. I was going through the back up procedure through the SQL Management Studio when I noticed there was an option to make a Copy Only Back Up. I looked it up to see what it was but I didn't fully understand the options I was getting.

http：// technet.microsoft.com/zh-cn/library/ms191495.aspx

我阅读了上面的条目以及其他条目，并且一直看到独立于常规SQL Server备份的顺序。

I read the entry above as well as other entries and I keep seeing the phrase "independent of the sequence of conventional SQL Server backups."

任何人都可以详细说明该语句对一般仅复制备份的含义或更多含义吗？我不确定在这种情况下是否应该备份？ （我的第一反应是否）

Can anyone elaborate what this statement means or more about Copy Only Backups in general? I'm not sure if it's the backup I should do in this case? (My first reaction is no)

推荐答案

通常，在进行备份时，备份开始（或继续，具体取决于备份的类型）您进行的备份）称为日志链。假设您需要数据库副本，无论出于何种原因，都不能出于此目的使用正常计划的备份。让我们来看一下您不使用仅复制备份的情况

Normally when you take a backup, it starts (or continues, depending on the type of backup that you took) what is called a log chain. Let's say that you need a copy of your database and, for whatever reason, you can't use your normally scheduled backups for this purpose. Let's walk through the scenario where you don't use a copy_only backup

1. 普通完全备份


2. 一堆差异备份


3. 另一个完整备份（用于创建副本数据库）


4. 更多差异备份


5. 删除第3步中的备份（您知道...以节省空间）


6. 实际数据库上的灾难，需要从备份中还原

1. Normal full backup
2. A bunch of differential backups
3. Another full backup (to make your copy database)
4. More differential backups
5. Delete the backup from step 3 (you know... to save space)
6. Disaster on your actual database that necessitates restore from backup

在这种情况下，您只能还原到步骤2中进行的最后一个差异备份，因为步骤4中进行的差异备份取决于步骤4中的完整备份。 3.现在，如果步骤3中的备份是copy_only备份，那么您会很好，因为您没有在重新建立日志链（也就是说，步骤4中的差异备份取决于步骤3中的完整备份）。 1。

In this case, you can only restore to the last differential backup made in step 2 because the differential backups made in step 4 depend on the full backup from step 3. Now, if the backup in step 3 were a copy_only backup, you'd be fine because you're not re-establishing a log chain (which is to say that the differential backups in step 4 depend on the full backup from step 1.

这篇关于这些“仅复制备份”选项是什么意思？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！