Rating: 
Summary: Still some legacy from 6.5 days
Review: Unfortunately I cannot share excitement of those who gave this book 4,5 or 5 stars. This book is good but still contains some mixture of old and new information. For example on page 259 authors claim that "incomplete transactions that occur after database process is started are NOT backed up", this is not true. In SQL 7.0 manual stated "Extents containing data are written to the backup set without regard to synchronizing pages being modified by users during the backup". They don't even mention new "Fuzzy backup" technology (see "Fuzzy Backup and Restore Operations" in BOL). On page 260 Authors claim that "performing full database backup does not clear inactive part of transaction log" this is also not true. Page 272 "The database log must reside on separate device from database": first there is no such thing as "device" in SQL 7.0, second there is no way to put database and log on the same file. Looks like they didn't cleaned up 6.5 manuscript properly.So, if you find something that does not supported by your practical experience, very likely you and not the authors are right.
| 
