If the primary server fails, users can be redirected to the
standby server manually.
??? Database mirroring: A completely new technology in SQL Server 2005, database
mirroring provides automatic failover. Unlike clustering, there is no shared data,
and the standby database can be on any server in any location.
Response Technologies
If this were a perfect world, mitigation techniques would always protect our systems and
data from disaster. This is not a perfect world. While mitigation techniques in disaster
recovery planning are useful, having a response plan is a requirement. Here are some
examples of response technologies:
??? Backup and restore: No database platform would be complete without functionality
to back up and restore a database. SQL Server 2005 provides additional
functionality such as mirrored backups and checksum validation.
??? File/filegroup backup and restore: SQL Server allows you to back up individual data
files or filegroups, though this method isn??™t used frequently. It can aid tremendously
in designing a backup scheme for a very large database (VLDB).
Pages:
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70