SQL Server 2000 Backup and Recovery (Database Professional's Library) - Softcover

Desai, Anil

Softcover

ISBN 10: 007213027X ISBN 13: 9780072130270

Publisher: Osborne/McGraw-Hill, 2000

Synopsis

SQL Server 2000 is at the core of Microsoft's e-business strategy. It is fully web enabled, with a data mining engine, and new security enhancements. The fast pace of e-business mandates that companies have superior back-up and recovery strategies that can anticipate and evade potential problems "before" they happen. With over 15 million users, Zona declares that SQL Server is the product of choice, with over 68% of the web market, beating out competitors like Oracle, IBM, Informix and Sybase. Osborne is updating this title to reflect the latest updates to SQL Server and to address the growing e-business community. "SQL Server 2000 Backup and Recovery" covers advanced clustering support, performance monitoring tools, the data mining engine, security enhancements, high-end data protection solutions, and more. This book is a one-stop resource for administrators and managers seeking to implement backup and recovery strategies with e-business objectives and shows how to maximize the new security enhancements in SQL Server 2000. It shows readers how to design a data protection plan and implement data restoration strategies, as well as how to gain an understanding of real-world problems and learn how to solve them through in-depth case studies.

About this title

About the Author

Anil Desai, MCSE, MCSD, MCDBA (Austin, TX) is a Technical Architect for QuickArrow, Inc. in Austin, TX. He has worked as an independent consultant for numerous companies ranging from global companies such as 3M and Motorola to small startups. Anil is the co-author of MCSE Fast Track: SQL Server 7.0 Administration (New Riders Press, 1999). He is also the author of Windows NT Network Management: Reducing Total Cost of Ownership (New Riders Press, 1999).

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: Osborne/McGraw-Hill
• Publication date: 2000
• Language: English
• ISBN 10: 007213027X
• ISBN 13: 9780072130270
• Binding: Paperback
• Edition number: 2
• Number of pages: 608