SQL Server 2000 Backup and Recovery - Softcover

Desai, Anil

Softcover

ISBN 10: 007213027X ISBN 13: 9780072130270

Publisher: McGraw-Hill Osborne Media, 2000

Synopsis

* 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

About this title

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.

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

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2000
• Language: English
• ISBN 10: 007213027X
• ISBN 13: 9780072130270
• Binding: Paperback
• Number of pages: 698