SQL Server 7 Backup & Recovery [Paperback]

Anil Desai (Author)

Book Description

Series: Database Professional's Library | Publication Date: February 3, 2000

-- Provides real-world information for database administrators to develop, manage, plan and implement a data protection solution.
-- Covers advanced tools and technologies for increasing uptime and performance, including clustering, replication, stand-by servers and advanced backup and recovery. Also reviews related information in data protection, security and performance on Windows NT4 and 2000.
-- Author is a recognized SQL Server expert and contributor to MCP Magazine. He speaks nationally on SQL Server.

Editorial Reviews

From the Back Cover

Protect your organization's most valuable asset--its data. Develop and implement a thorough data protection solution for your SQL Server 7 database environment. SQL Server 7 Backup & Recovery is your one-stop resource for planning, developing, implementing, and managing backup and restore procedures. Learn to execute data protection strategies, implement a backup solution, and handle data recovery before potentially disastrous data loss occurs. You'll get details on the latest methods for increasing database uptime and improving performance. The case studies included show you how to apply the techniques described in the book in your own environment. Evaluate business requirements and develop a data protection strategy. Configure Windows NT/2000 for the secure and efficient use of SQL Server 7. Select the best hardware, software, and network technologies for your backup plan. Handle SQL Server 7 backup procedures involving files and filegroups, transaction logs, concurrency, locking, and other database issues. Increase database uptime and optimize performance. Develop and practice restore plans for various scenarios--from minor data loss to complete hardware failures. Increase reliability, availability, and performance through the use of standby servers and clustering. Distribute data throughout your enterprise with SQL Server 7's replication features. Follow case studies to learn about the application of data protection best practices in various environments.

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.

Product Details

• Paperback: 480 pages
• Publisher: Mcgraw-Hill Osborne Media (February 3, 2000)
• Language: English
• ISBN-10: 0072124105
• ISBN-13: 978-0072124101
• Product Dimensions: 9.2 x 7.2 x 1.2 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 3.0 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #5,585,648 in Books (See Top 100 in Books)

More About the Author

Anil Desai is an independent consultant based in Austin, TX. He specializes in evaluating, implementing, and managing IT solutions. He has worked extensively with Microsoft's Server products and the .NET / SQL Server development platforms. Anil is an MCSE, MCSD, MCDBA, MCITP, and a Microsoft MVP (Windows Server - Virtualization).

Anil is the author of numerous technical books focusing on the Windows Server Platform, Virtualization, Active Directory, SQL Server, and IT management. He has made dozens of conference presentations at national events and is also a contributor to technical magazines. For more information, please see http://AnilDesai.net, or e-mail [e-mail].

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

2.0 out of 5 stars SQL DBA would not feel it much useful, May 11, 2000

By 

[e-mail] - See all my reviews

This review is from: SQL Server 7 Backup & Recovery (Paperback)

I bought this book because of its name. However after I read it, I am very disappointed.

The reason is that

1. It does not not cover in-depth experience/knowledge/troubleshooting. 2. The details of the table are like a plate of salad. So much NT and SQL Server basic stuff most of reader should already know and do not want read it. 3. The most disappointing part is that it does not touch real-world trouble from SQL DBA about backup and restore.

5 of 6 people found the following review helpful:

1.0 out of 5 stars Don't Bother Buying This Book, May 30, 2000

By 

Brad M McGehee - See all my reviews

This review is from: SQL Server 7 Backup & Recovery (Paperback)

While I would love to find a great book on advanced backup and recovery techniques for SQL Server 7, this is not the book. This book is far to general and full of fluff to provide the information you really need. It many ways, the book tries to cover a little of everything about being a SQL Server DBA, but it ends up doing a poor job of covering any topic.

I was hoping to find advanced information on log shipping and clustering. While these topics are touched on, they don't provide you the information you really need.

If you need a book on the basics of SQL Server 7 backup, most any book covering basic SQL Server 7 DBA responsibilities should fit the bill. This book is a waste of your time.

1 of 3 people found the following review helpful:

4.0 out of 5 stars Recommended for DBAs, August 2, 2000

By A Customer

This review is from: SQL Server 7 Backup & Recovery (Paperback)

Agree with above comments regarding technical details on log shipping and clustering... But this book really gives what I needed for planning db backups at my company. I wish more technical people would take the time to well plan for backups instead of focusing on implementation which you cvan lookup in Books Online.