You can truly secure a backup by placing it on an encrypted file system or physically
securing a tape in a safe. Of course, third-party backup tools can encrypt backup data as
the backup is occurring.
You can secure data by encrypting the actual columns in the database before a
backup even begins. SQL Server 2005 supports native encryption, using industrystandard
encryption algorithms. If your database contains extremely confidential information,
such as credit-card information, it is probably better to encrypt it within the
database rather than simply relying on some sort of backup encryption or password.
Striped Backup
Sometimes databases are so large that creating a full backup on a single tape or disk array
is next to impossible. In these instances, you can use striped backups, sometimes known
as multiplexing. Figure 2-7, for example, shows a backup being striped (or written simultaneously)
across four tape drives. The advantage is that each device is being used to its
fullest capacity to create the backup. The disadvantage is that in the event of a failure, all
tapes or files will need to complete a restore.
Pages:
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107