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 112 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"

. .???). 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