|
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 |