Overview
Provides real-world information for database administrators to develop,manage,plan and implement a data protection solution. Coves 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.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. Distributedatathroughout 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.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewA 450-page book about SQL Server 7 backup and recovery? Especially given that Microsoft has made the actual backup and recovery process easier than it's ever been? Heck, yes. And if you're staking your business on SQL Server 7 databases, you really need this book.
You need it because Anil Desai doesn't simply cover the mechanics. (Though the mechanics have never been covered with more detail or clarity. —and there's more to the mechanics than you might have realized, including Transact-SQL commands for creating custom jobs, multiserver administration, and the challenge of getting everything done within an ever-narrowing backup window.)
You need it because Desai covers the entire process of protecting your SQL Server 7 data—from evaluating your requirements through planning, selecting disks, UPSs, media, third-party software solutions, and more.
There's more: Desai covers SQL Server 7 replication across multiple servers; partitioning; clustering, and other advanced techniques. SQL SERVER 7 BACKUP & RECOVERY also offers four fictional case studies showing how companies of varying sizes can implement cost-effective, reliable data protection.
So, it's 10 pm. Do you know where your SQL Server data is?
—bncom editor