I would never advocate the use of such a lowlevel
approach for backing up a database in Simple Recovery mode. In every case where I??™ve used it, the
system required that approach because it was a high-transaction system that required minimal maintenance
time. Constructing a complex file/filegroup backup/restore scheme while in Simple Recovery mode taunts
the fates. Don??™t do it. Remember, the transaction log is your life!
Backing Up Database Files
Files are backed up with the usual BACKUP DATABASE command. You need to specify the
database and each file to be backed up??”for example:
BACKUP DATABASE AWSample
FILE='D:\Data\AWData2.NDF'
TO DISK = 'E:\BackupData\AWData1.BAK'
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 87
Rather than some examples that show multiple files listed, the payoff with file backups
is to perform them file-by-file over a longer period of time. The illustrated backup is
often called a full-file backup, because you can follow it up with differential file backups.
NEED FOR REALISTIC DATABASE FILE SIZES
Theoretically, a single database file can be as large as 16TB.
Pages:
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192