Chapter 2. Data Corruption and Recovery Issues

By Bob Ward

In This Chapter

• Fundamentals

• SQL Server 2005 Storage Internals

• SQL Server 2005 Enhancements

• Data Recovery Best Practices

• Data Recovery Troubleshooting Scenarios

• User Database Inaccessible

• BACKUP/RESTORE Failures

• Database Consistency Errors

All the troubleshooting concepts discussed in this chapter relate to one common goal: protection and recovery of your most important asset—your data!

What is the key to recovering your data? The answer is simple. Restore from a valid backup. But you bought this book to find out “tips and tricks” for data recovery, and all I have told you is to restore from backup. Is that all? Well, not just that, but I am telling you that restoring ...

Get SQL Server 2005 Practical Troubleshooting: The Database Engine now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial