Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

SQL Server 2000 Backup and Recovery [Paperback]

Anil Desai
1.5 out of 5 stars  See all reviews (2 customer reviews)

Available from these sellers.



Book Description

Nov. 15 2000 Database Professional's Library
* Microsoft's eBusiness solution--SQL Server 2000--is fully Web enabled and includes a new data mining engine, new security enhancements, as well as increased support for XML, HTTP, larger clusters, and 64-bit Windows
* SQL Server holds 68% of the Web market
* This book explains how to design a data protection plan, implement fail-over clustering, maximize the new security features in SQL Server 2000, and handle data restoration
* Essential book for database professionals--without backup and recovery strategies in place, a simple hardware failure could disable a company

Product Details


Product Description

From the Back Cover

Secure your company's mission-critical data

Plan for an implement a sound SQL Server 2000 data protection solution. SQL Server 2000 Backup & Recovery explains in detail how to develop a strategy based on your business requirements, select hardware and software, plan for data storage, perform backups, and execute data restore procedures. The focus is on practical, real-world information that you can immediately apply in your own environment. Case studies and scenarios illustrate how to apply all the methods presented in the book. Increase SQL Server performance and provide high levels of data protection with help from this practical resource.

  • Create a valid data protection plan based on business requirements
  • Configure and manage security and data protection in Windows NT/2000
  • Understand SWL Server 2000 architecture, including transaction logs, concurrency, locking, and data storage features
  • Determine the best hardware and software for your backup and recovery operations
  • Plan for and perform full, differential, and transaction log backups
  • Design data storage solutions using RAID, file groups, and other SQL Server 2000 technologies
  • Develop restore plans to accommodate everything from minor data loss to complete system failures
  • Implement advanced data protection to increase reliability and uptime using replication, standby servers (log-shipping), and fail-over clustering

About the Author

Anil Desai, MCSE, MCSD, MCDBA, is Technical Architect for QuickArrow, Inc., in Austin, Texas. He has consulted for several companies, ranging from small startups to multinational organizations. Anil is the author of Windows NT Network Management: Reducing Total Cost of Ownership and MCSE: Windows 2000 Directory Services Implementation Exam Guide, and co-author of MCSE Fast Track: SQL Server 7 Administration.

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

5 star
0
4 star
0
3 star
0
1.5 out of 5 stars
1.5 out of 5 stars
Most helpful customer reviews
2.0 out of 5 stars Most of the book are fillers Aug. 23 2001
Format:Paperback
Most of the contents of this books are fillers. It is obvious the publisher (Osborne) demanded the author to write a 500 page book in order to justify the exorbitant cost of this book.
The real information on backup and recovery does not start until page 331!!!!! The author is a good writer and obviously had lot of IT experience. He does his best to make the book as informative as possible. But it is apparent that backup and recovery information is not worth 500 pages of text.
I think the book could have been salvaged quite well if the last chapter on case studies of backup and recovery scenario was better written, but this is where the author REALLY bombed. His recovery steps can all be summarized as recovering the full, then incremental, then transaction logs. Anyone who knows ANYTHING about SQL recovery knows THAT.
Was this review helpful to you?
1.0 out of 5 stars Not a Backup & Recovery book. July 18 2001
Format:Paperback
The Backup & Recovery techniques could have been put in less than one third the size of this book. But the book goes needlessly into many of the MS SQL Server 2000 features that have absolutely nothing to do with Backup/Recovery at all. For example, what does Profiler have to do with backup/recovery? Or step by step configuration of SQL Server? If you start at page 305 and stop at page 510, you have read all there is to know about backups and restores. Beyond page 510 are some interesting special purpose topics like Replication and Log shipping etc, which can come in handy for a high availability OLTP systems. However, first four chapters are unnecessary details about NT security and SQL Server 2000 Architecture. Wait for a more focused book.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 1.3 out of 5 stars  3 reviews
8 of 9 people found the following review helpful
1.0 out of 5 stars Not a Backup & Recovery book. July 18 2001
By "axk1023" - Published on Amazon.com
Format:Paperback
The Backup & Recovery techniques could have been put in less than one third the size of this book. But the book goes needlessly into many of the MS SQL Server 2000 features that have absolutely nothing to do with Backup/Recovery at all. For example, what does Profiler have to do with backup/recovery? Or step by step configuration of SQL Server? If you start at page 305 and stop at page 510, you have read all there is to know about backups and restores. Beyond page 510 are some interesting special purpose topics like Replication and Log shipping etc, which can come in handy for a high availability OLTP systems. However, first four chapters are unnecessary details about NT security and SQL Server 2000 Architecture. Wait for a more focused book.
4 of 4 people found the following review helpful
2.0 out of 5 stars Most of the book are fillers Aug. 23 2001
By Jaewoo Kim - Published on Amazon.com
Format:Paperback|Verified Purchase
Most of the contents of this books are fillers. It is obvious the publisher (Osborne) demanded the author to write a 500 page book in order to justify the exorbitant cost of this book.
The real information on backup and recovery does not start until page 331!!!!! The author is a good writer and obviously had lot of IT experience. He does his best to make the book as informative as possible. But it is apparent that backup and recovery information is not worth 500 pages of text.
I think the book could have been salvaged quite well if the last chapter on case studies of backup and recovery scenario was better written, but this is where the author REALLY bombed. His recovery steps can all be summarized as recovering the full, then incremental, then transaction logs. Anyone who knows ANYTHING about SQL recovery knows THAT.
1.0 out of 5 stars Don't buy this book Feb. 3 2005
By Tim - Published on Amazon.com
Format:Paperback
This book is not a SQL server Backup and Recovery book.
Search Customer Reviews
Only search this product's reviews
ARRAY(0xa9732b84)

Look for similar items by category


Feedback