|
|
|
|
How to restore database to the point of failure? Back
If your database's recovery modal is "Simple" , you can not restore to the point of failure , in this case , please select the latest differential and full backup do the restore. If your database's recovery modal is not "Simple" , to restore database to the point of failure :
1) . Back up the tail of transaction log after SQL Server fails .
To get this type of transaction log backup , please select the backup type "Do not remove inactive entries from transaction log." , see following instruction. If this step is fails , it indicates that the storage log file may have problems , it can not be read , in this case , the database can not be restored to point of failure .
2) . Remove the error the cause the database fails .
3) . Create a new restoration job and select this transaction log backup to restore the database .
|
|
|
Home