How can we help you today? How can we help you today?

Wrong Restore Status in Email OnError

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

Comments

2 comments

Sort by
  • petey
    This is a know issue with SQL Backup v3, where it cannot detect SQL errors. Version 4 addresses this problem, by reporting both SQL Backup and SQL Server errors.
    petey
    0
  • Brian Donahue
    Hello,

    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.