SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 194 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"


??? Hardware: One of the key purposes of using filegroups is separating I/O, so using
multiple RAID controllers, channels, or arrays to house separate files or filegroups
can drastically reduce recovery time??”that is, if you??™re lucky enough not to lose the
hardware where the log backups reside.
??? Media: As with hardware failures, using file or filegroup backups can drastically
reduce the restore time if separate media groups are used. This caveat applies not
only to on-disk backups but also to tape backups.
??? Process: The restore process can be reduced if tables and indexes are strategically
placed. For example, if you??™re updating a specific table, you could back up the filegroup
that owns it, run the procedure, then restore the backup if the procedure
fails.
??? User: Again, if designed properly, you might be able to restore only the affected filegroup
in the event of a user error. The user error still can end in data loss, but the
impact may not be as great.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 96
Caveats and Recommendations
Performing filegroup or file backup/restore operations can be fraught with missteps if
you don??™t take care.


Pages:
182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206
hotel jelenia góra Russian bride Free English grammar and study guid powiekszenia wielkoformatowe counter strike 1.6