Wrong Restore Status in Email OnError
essamughal
Posts: 35
Hi All;
I have been evaluating SQL Backup and I ran so many test. One test which I preformed is that.
1- Create Transactional Log 1 and Transactional Log 2
2- Skip Log 1 (did not restore that log)
3- Restore log 2
Result:
It moved the file Log 2 to processed folder and report SUCCESS but it did not apply the log b/c I checked the data
Then I checked the log of the Red-Gate SQL Backup and I found that there was Error b/c the Sequenece of the Log was not accurate so the Restore process was terminated abnormally but it did Report SUCCESS in email and did not show any error.
Have any experienced that problem with Red-Gate.
thanks
I have been evaluating SQL Backup and I ran so many test. One test which I preformed is that.
1- Create Transactional Log 1 and Transactional Log 2
2- Skip Log 1 (did not restore that log)
3- Restore log 2
Result:
It moved the file Log 2 to processed folder and report SUCCESS but it did not apply the log b/c I checked the data
Then I checked the log of the Red-Gate SQL Backup and I found that there was Error b/c the Sequenece of the Log was not accurate so the Restore process was terminated abnormally but it did Report SUCCESS in email and did not show any error.
Have any experienced that problem with Red-Gate.
thanks
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
I believe that the issue you're talking about is the one discussed here:
http://www.red-gate.com/messageboard/vi ... .php?t=974.
SQL Backup v4 fixes this problem because it contains a scheduling wizard that scripts the necessary SQL Agent alert for you automatically.