Skip to main content
removed duplicate tag in heading
Link
Zach Smith
  • 2.4k
  • 13
  • 34
  • 64

SQL Server: Are non 'copy-only' full backups safe to recover from?

Tweeted twitter.com/StackDBAs/status/826531193013284864
Source Link
Zach Smith
  • 2.4k
  • 13
  • 34
  • 64

SQL Server: Are non 'copy-only' full backups safe to recover from?

I've recently realized the difference between a full backup and a 'Copy-only' full backup and I'm wondering if the backups I'm taking on a weekly and daily basis are safe to recover from.

This article suggests that differential backups can only be traced back to a 'parent' (if that is the correct word) full backup. To me this sounds like a DB with FULL recovery mode allows for a point-in-time recovery to the last full backup?

In any case. I'm currently taking a full backup on a daily basis and no differential backups. Some of the databases being backed up have a recovery mode of simple, some full and some are bulked-logged. However, there is no need to do point in time restore on any of them at this point (These databases are updated once a day via vendor dumps). I'm also not taking any transaction log backups of the full-recovery mode databases for now (because I don't know how to do this automatically yet I'm watching them manually until they start growing faster than they currently do).

Am I right in thinking that a database can be restored from a full-backup at the time that full-backup was taken, regardless of the recovery model and regardless if there is a log backup or not?