Résumé
Microsoft SQL Server backup: in-depth, start-to-finish, for every DBA!
- The most complete guide to SQL Server 2000 backup and recovery!
- Step-by-step coverage for backing up and restoring your databases, log shipping, and proper DBCC usage
- Making the most of factory-delivered SQL Server backup, restore and diagnostic tools
- Includes coverage of SQL Server in Windows(r) environments for XP and 2000
- Contains scripts and sample code for streamlining backup and recovery!
Written by a Microsoft senior consultant who specializes in SQL Server enterprise deployments, SQL Server Backup and Recovery is a comprehensive guide to protecting and restoring SQL Server databases. The book is organized to serve as both a hands-on tutorial and a long-term reference. Coverage includes:
- What every DBA needs to understand about SQL Server backup and recovery architecture and algorithms
- Planning for backup and recovery: time windows, recovery scenarios, and backup strategies
- Making the most of SQL Server's built-in backup and recovery and diagnostic tools
- Recovering the master database, step by step
- Installation and role changing with log shipping
- How to properly use SQL Server's DBCC commands
SQL Server Backup and Recovery contains scripts and sample code designed to automate and streamline the backup and recovery process—tools field-proven in enterprise deployments. If you're responsible for protecting the data in a Microsoft SQL Server database, this is the realistic, systematic guide you've been searching for!
ContentsIntroduction.
Acknowledgements.
1. Planning, Architecture Overview, and Practical
Experience.
Planning Your Backup and
Recovery. The Role of Backups. You're Only as Good as Your
Last “Good” Backup. Types of Backups. How
BACKUP Works. Databases You Should Back Up. Database
Maintenance Plans. Backup Security. How RESTORE Works.
Recovery Models. How Recovery Models Work. Setting Recovery
Models. Changing Recovery Models. Limitations on Recovery
Models. Recovery Model Backup Compatibility Matrix.
Practical Experience.
2. Backing Up Data in SQL Server.
SQL Server Tools. Backup
Devices. Using Enterprise Manager to Define a Backup
Device. Using Transact SQL to Define a Backup Device.
Adding a Disk Backup Device with sp_addumpdevice. Adding a
Tape Backup Device with sp_addumpdevice. Viewing Backup
Devices. Dropping Backup Devices. Introduction to Backup
Methods. Using the EM to Run a Backup. Using the Command
Line to Back Up a Database. Backing Up a Database to Disk.
Backing Up a Database to Tape. Making a Differential
Database Backup. Backing Up Filegroups. Transaction Logs.
Transaction Log Backup. Recovering the Tail of a
Transaction Log. Backing Up a Whole SQL Server. Offline
Backup. Backing Up an Entire Online Server. Backing Up a
Table. Select Into. bcp. Running bcp. Data-Loading
Strategies and bcp. DTS. DTS Performance Considerations.
Flat File Backups. Performing Cold Backups of an NT File.
Filesystem Backup: Architecture and Performance
Considerations. Using sp_detach_db to Back Up. Scheduling
Backups. Using SQL Server Agent with Your Backups. Using
AT. Integrating E-Mail into Your Backup. Backup Performance
and Operational Considerations. Striping with Tape Systems.
Compression: Tape, OS, and Databases. Long-Term Storage.
Compressed Volumes and SQL Server: Databases, Transaction
Logs, and Backups. Monitoring the Completion of a Backup.
Monitoring the Performance of a Backup. Tuning Up
BACKUP.
3. Restoring Data to SQL Server.
Appended Backups.
Restoring a Database from Disk. Restoring a Database from
Tape Using the Command Line. Large Restore from Tape. How
to Restore a Database Using Transaction Logs. Assumptions.
Process. Example. Recovery with Differential Backups.
Assumptions. Process. Example. Restoring from a
Differential Backup with Transaction Logs from a Tape
Device. Restoring to a Point in Literal Time from Tape.
Full Backup with Multiple Transaction Logs. Bringing It All
Together: Moving Data Centers Using Standby Servers. Source
Database Server. Target Standby Database Server. Other Uses
for a Standby Server. Moving Database Files on a Restore.
Restoring to a Marked Transaction. Results of Script.
Restoring Files and Filegroups. Example. Recovering msdb.
Example. Restoring Usernames and Logins. Recovering a
Database with a Transaction Log Only. Example.
4. Recovering the master Database.
Rebuilding and Recovering
the master Database. Scenario. Restoring the master
Database. Potential Problems in Rebuilding and Restoring
the master Database. Recovering Other Databases after
master Has Been Rebuilt. Using the RESTORE Command. Using
the sp_attach_db Method. Notes on Logins and Users after a
master Rebuild. Program to Generate Logins from the User
Database. Remapping Orphaned Users. Recovering msdb.
Process. Script.
5. Data Recovery Tools and Techniques.
Establishing a Game Plan.
Sizing Up the Situation. Common Diagnostic Tools. DBCC.
SQLDIAG.EXE. Introduction to DBCC PAGE. DBCC PAGE Syntax.
Finding and Repairing Corrupt Data with DBCC CHECKDB. Using
Indexes to Recover Data. Case One. Case Two. Corruption
That's Hard to Detect. Fixing Corrupt Nonclustered Indexes.
Backing Up and Restoring Corruption. Retrieving Data Using
DBCC PAGE. Using sp_attach_single_file_db to Recover an MDF
File.
6. Log Shipping.
Pros and Cons of Some
High-Availability Solutions. Simple Log Shipping.
Preliminary Steps. Creating a Maintenance Plan for Log
Shipping. Explanation of the Files. SQL Agent Jobs.
Maintenance Plans. Testing to See if Log Shipping is Really
Working. Removing Log Shipping. Two Secondary Servers.
Creating a Maintenance Plan for Log Shipping with Two
Secondary Servers. Primary/Secondary to Primary/Secondary.
Failing Over: Network Load Balancing Router. No Recovery
Mode and Standby Mode. Log Shipping Monitor. Viewing the
Log Shipping Monitor. Role Change to the Standby Log
Shipping Server. Failing Over if Both Servers Are
Accessible. Logins and Users During Log Shipping. Failing
Over in an Emergency: Only the Destination Server Is Up.
Re-Establishing Log Shipping After Recovering the Primary.
Good Ideas Before Failing Over. Potential Problems During
Log Shipping.
Appendix A: An Efficient and
Flexible Method for Archiving a Data Base.
Appendix B: ER Diagrams.
Appendix C: Acronyms and Abbreviations.
Bibliography.
Index.
L'auteur - Franck McBath
FRANK McBATH is an SQL Server specialist in Microsoft's
Enterprise Applications Practice specializing in
architecting and implementing large database installations.
Before joining Microsoft, McBath worked for several Fortune
100 firms and consulting houses.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Prentice Hall |
| Auteur(s) | Franck McBath |
| Parution | 05/02/2002 |
| Nb. de pages | 292 |
| Format | 17,5 x 23,3 |
| Couverture | Broché |
| Poids | 613g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780130622983 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
