| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Troubleshooting and Error Messages Guide |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2 Encyclopedia of Tasks |
Chapter 2
This chapter provides step-by-step procedures for tasks needed to recover from various disaster situations involving Sybase system databases or the entire master device, as well as for other tasks not strictly related to disaster recovery.
Although this chapter provides examples for a range of platforms, availability of Adaptive Server Enterprise varies. For example, Stratus, OpenVMS, Novell Netware, and OS/2 are not available on all server versions.
|
| Disaster Recovery Tasks |
![[+]](/dwicons/i_expand.gif)
| How to Build a New Master Device |
|
| How to Rebuild master Database and Leave Master Device Intact |
|
| How to Start Adaptive Server in Single-User Mode |
| How to Run the installmaster and installmodel Scripts |
| How to Load the master Database from Backup |
|
| How to Restore System Table Information in master Database |
| How to Alter the number of devices Parameter Manually |
| How to Alter tempdb |
| How to Alter the model Database |
| How to Reset Adaptive Server to Its Default Configuration |
| How to Set A Default Backup Server Manually in Adaptive Server |
| How to Fix Problems Encountered by Disk Refit |
| Problem 1: Duplicate Keys |
| Problem 2: Deleted Database dbid |
| Problem 3: Allocation Pages from Deleted Database |
| Problem 4: Incomplete sysusages Entries |
| Queries to Find Suspect sysusages Entries |
| Avoiding Disaster through Good DBA Practices |
|
| Online Recovery and Recovery Fault Isolation |
| Background |
|
| Online Recovery Concepts |
|
| Recovery With RFI |
|
| What To Do When Online Recovery Fails |
| RFI Example |
|
| How to Manually Change Sort Order or Default Character Set |
| Manual Process |
| How to Load a Sort Order or Additional Character Set |
| How to Change the Sort Order |
| How to Change the Default Character Set |
|
| How to Find a Sort Order File Name |
| How to Find a Sort Order ID |
| How to Find a Character Set ID |
| How to View Your Existing Sort Order and Character Sets |
|
| Useful dbcc Commands |
| Standard dbcc Commands |
|
| Other dbcc Commands |
|
| How to Analyze dbcc checkstorage Faults |
| Fault Analysis |
| dbcc checkstorage startup and drop table |
| Faults Due to sp_placeobject |
|
| Troubleshooting XP Server Issues |
| Background |
| Correcting Common XP Server Problems |
| Information to Collect Before Calling Technical Support |
|
| Other Useful Tasks |
|
| How to Fix a Corrupted Index on System Tables |
|
| How to Rescue Data from a Corrupted Table |
|
| How to Start Adaptive Server with Trace Flags |
| How to Reload a Suspect User Database |
| How to Drop a Database When drop database Fails |
|
| How to Fix and Prevent Allocation Errors |
| How to Find an Object Name from a Page Number |
| How to Interpret sp_who Output |
| Device Administration Issues |
|
| How to Choose Between Raw Partitions and UNIX Files |
| How to Move a Sybase Device or Database With Disk Mirroring |
|
| How to Gather Information About Read/Write Errors |
|
| How to Mark a Database "suspect'" |
|
| How to Reset a Database's "suspect" Status |
|
| How to Find a Device's Virtual Device Number |
|
| How to Detect and Clear Long-Running Transactions |
|
| How to Reduce the Size of tempdb |
|
| How to Remap All Objects in a Database |
|
| How to Prepare for Analyzing an Optimizer Problem |
| How to Determine Which Physical Devices a Database is On |
| How to Identify and Fix a Corrupted Table |
| How to Monitor the Error Log |
|
| Checking the Operating System Error Log |
|
| How to Obtain a CSMD Dump |
|
|