What is the difference between "Files aned File Groups" backup and Partial Backup?
Looks like both are same.. Please comment.
A File Group backup is a backup which only saves the data from the named file group(s).
A Partial backup is also a backup which only saves the data from some file groups, but it usually refers to the syntax:
BACKUP DATABASE foo READ_WRITE_FILEGROUPS TO....
which backs up only the primary filegroup and any read-write filegroups.
If you have a good backup of the read-only filegroups, you don't need to save them at every backup, which limits volume.
So, a Partial backup is a special case of a File Group backup.
No comments:
Post a Comment