SGU forum MIA?

[rjh01]

Nope, not getting it. A backup should restore or rebuild the indexes as well. Unless the backup was just a data dump, but that's not a backup.

Works for me. This is the link https://sguforums.com/

 

[Fast Eddie B]

Yep. Been back up for a while now.

 

[a_unique_person]

No, I mean a backup for a database should be able to be used to restore everything in one process.

 

[smartcooky]

No, I mean a backup for a database should be able to be used to restore everything in one process.

... unless the backup itself contained undetected corrupt data which is what I believe happened. You can read about it here...

https://sguforums.com/index.php/topic,51738.new.html#new

 

[a_unique_person]

Roll Forward should fix that. I have had to do it once. Go back to your known good backup then roll forward to re-apply the log files.

 

[abaddon]

Roll Forward should fix that. I have had to do it once. Go back to your known good backup then roll forward to re-apply the log files.

According to the announcement on SGU there was a daily backup schedule. So in theory, that would require little effort to go back to the last good backup. Rolling forward the trans logs would be a matter of choice at that point. Lose a couple of days activity or fiddle about trying to recover as much as possible. Cost benefit calculation. The loss of a day or two of activity would not be disaster on SGU. It's not bank records or medical records, after all.