. .???). According to the story, two consultants are updating a database, and they need to delete
a few invalid records. Consultant #1 types in DELETE FROM Order and executes, gasping in shock as
he does; he realizes that he just issued a DELETE command for the entire table, which contains more
than 14 million order records. Consultant number #2 immediately runs to the server room, finds the
SQL Server, and unplugs the power.
When SQL Server restarts, it sees that DELETE statement as an uncommitted transaction (it
wouldn??™t commit until the final row was deleted). It reverses the DELETE that was issued by rolling
back all of the rows it had deleted successfully. Consultant #1??™s job is saved, and all is well throughout
the land.
Looking at these simple descriptions, you may be thinking, ???I already knew that??? or
???That??™s not so confusing.??? The problem is that RESTORE is an explicit statement, whereas
recovery will occur implicitly if it??™s not controlled manually. If only a single, full backup
file is being restored, recovery isn??™t something you need to concern yourself with.
Pages:
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124