|
|
| System Security Principles | 602SQL Server Administration |
If a database gets damaged, you can use the following methods for its restoration:
| Problem | Solution |
| Damaged indices (search and sort errors) | Rebuild indices of affected tables |
| Database file integrity errors | Running integrity maintenance |
| Unrecoverable damage to a database | Database restoration from the backup file |
| Important data deleted | Database restoration from the backup file and its actualization using the journal, with removing specific user actions over a specific period |
| Server cannot be run over a database | Database patching |
| Other not specified errors | Move the database contents to a new database |
List of topics:
| System Security Principles | 602SQL Server Administration |