It is possible to restore the DB from backup. Basically the process entails:
- Stop all PA processes (middleware and collector)
- Restore the DB repository
- Start the middleware then the collectors
Do note however, that the above assumes no new collectors were added after the DB backup you are restoring. If so, the restore will not recognize these new collector/s until they are associated with the repository.
Only the data loss in the gap of time between the backup and when the collectors begin reporting again should be the potential issue.