You can use Appliation Item restore feature in order to replay transaction log and see if that fixes the issue. That operation will be performed only on the specified database. If the corruption was caused, for example, by memory or power failure then replaying logs should help you to recover the database to the state when the latest log backup was performed, with minimal loss of data. If you wish to recover from the tail of log that has not been copied by Veeam yet then you have to apply SQL transaction logs to the most recent db restore point manually.How can you recover from a database corruption discovered by CheckDB without loss of transactions, loss of data, nor impact to availability of other databases on the same SQL Server
I believe that some misunderstanding is involved here. I never said there would be no loss of data at all, I said there would be minimal loss of data. Instant Recovery is just fast and easy way to get a testing range for recovery procedures so you don't make harm to your production in case something goes terribly wrong, that's what I meant when offered you to use Instant Recovery in conjunction with SQL restore. Sorry for confusion.<...>Is not correct.
It is not always possible to repair errors shown by DBCC CheckDB without loss of data as was the case in this instance. That is why in the past we have used SQL Backups and SQL Log Backups with a tail of log backup in this situation which allows you to recover from the corruption without loss of data.<...>
Correct. We will take a closer look at this limitation in order to improve the way how SQL point-in-time restore procedure works now. Thank you for pointing that out.Unfortunately application item restore in order to replay transaction logs does not work when the database to restore is one or more backup job executions prior to the current back up job execution as in my post you will see Veeam does not allow the restore of logs from multiple backup job executions.
Veeam does not allow the restore of logs from multiple backup job executions
Users browsing this forum: Bing [Bot], Google Feedfetcher and 26 guests