| |
Home |
Return to Collection List
Enable Frames
| System Administration Guide |
![[+]](/dwicons/i_expand.gif)
| About This Book |
|
| Chapter 1 Overview of System Administration |
|
| Chapter 2 System and Optional Databases |
|
| Chapter 3 System Administration for Beginners |
|
| Chapter 4 Diagnosing System Problems |
|
| Chapter 5 Setting Configuration Parameters |
|
| Chapter 6 Limiting Access to Server Resources |
|
| Chapter 7 Configuring Character Sets, Sort Orders, and Languages |
|
| Chapter 8 Configuring Client/Server Character Set Conversions |
|
| Chapter 9 Security Administration |
|
| Chapter 10 Managing Adaptive Server Logins and Database Users |
|
| Chapter 11 Managing User Permissions |
|
| Chapter 12 Auditing |
|
| Chapter 13 Managing Remote Servers |
|
| Chapter 14 Using Kerberos, DCE, and Windows NT LAN Manager |
|
| Chapter 15 Overview of Disk Resource Issues |
|
| Chapter 16 Initializing Database Devices |
|
| Chapter 17 Mirroring Database Devices |
|
| Chapter 18 Configuring Memory |
|
| Chapter 19 Configuring Data Caches |
|
| Chapter 20 Managing Multiprocessor Servers |
|
| Chapter 21 Creating and Managing User Databases |
|
| Chapter 22 Setting Database Options |
|
| Chapter 23 Creating and Using Segments |
|
| Chapter 24 Using the reorg Command |
![[-]](/dwicons/i_colpse.gif)
|
|
| What is the database consistency checker? |
|
| Understanding page and object allocation concepts |
| What checks can be performed with dbcc? |
|
| Checking consistency of databases and tables |
|
| Checking page allocation |
| Correcting allocation errors using the fix | nofix option |
| Generating reports with dbcc tablealloc and dbcc indexalloc |
| Checking consistency of system tables |
|
| Strategies for using consistency checking commands |
|
| Verifying faults with dbcc checkverify |
| Dropping a damaged database |
|
| Preparing to use dbcc checkstorage |
|
| Maintaining dbccdb |
|
| Generating reports from dbccdb |
|
| Chapter 26 Developing a Backup and Recovery Plan |
|
| Chapter 27 Backing Up and Restoring User Databases |
|
| Chapter 28 Restoring the System Databases |
|
| Chapter 29 Managing Free Space with Thresholds |