Media Sets and Backup Sets
Every backup belongs to a backup set, and every backup set belongs to specific media
set. I have rarely encountered anyone who uses these features explicitly. Backup ???agent???
software that integrates with a larger backup management tool often creates names just
for the purpose of internal organization:
BACKUP DATABASE AdventureWorks
TO BACKUPDEVICE1
WITH RETAINDAYS=7,
NAME='Full',
MEDIANAME='ALLAWBackups'
NAME refers to that specific backup set, and MEDIANAME is a label for BACKUPDEVICE1.
Unless you??™re in the practice of storing multiple backup files within a single backup
device or file, it??™s best not to use these. If you??™re using a third-party backup agent, let the
agent control the MEDIANAME and NAME properties.
nTip Although there is an advantage to using a file-based backup device from an organizational perspective,
I generally avoid doing so. I prefer a single file for each distinct backup, whether it??™s a full backup, a
differential, or a log. The larger a file grows, the longer it will take to be moved, and the opportunity for corruption
to the entire backup set grows.
Pages:
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97