This complies with SAP recommendations that at least the following components of your system should be located on different disks: This documentation assumes that you have distributed your system to 3 different disk systems. The procedure to follow in order to repair a damaged database after disk failure differs, depending on how files have been allocated to disks and which of these disks have been damaged. The following describes different error situations and gives an overview of the steps required to restore the database in these situations. Finding out exactly what happened is therefore the first step in any restore process. The most effective method to restore a database depends on the type of error that has occurred. This means open transactions are rolled back and completed transactions that were not written to the data files at the time of shutdown are re-executed. When the database is restarted, an automatic recovery mechanism starts working. The SQL Server has an automatic recovery mechanism to deal with this situation. When the power is cut off, the system shuts down abruptly and the execution of transactions is interrupted. After a power failure the database does not have to be restored.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |