How do I know which databases have backup

Backup Archive and Restore (BAR)
All things BAR
Highlighted

How do I know which databases have backup

Hello,
I am struggling with a problem. How do i know which databases have backup ?
I tried using DBC.QRYLOG, but it didn't work.

 


Accepted Solutions

Re: How do I know which databases have backup

Hi,

DSA - stores info in SYSBAR.BAREVENTSV table. Also you can try: dbc.qrylogutilityv where utilityname='BAR'.  

 

For non-DSA backups, dbc.events table with eventtype='dump' would give this informatino.

 

 

1 ACCEPTED SOLUTION
1 REPLY

Re: How do I know which databases have backup

Hi,

DSA - stores info in SYSBAR.BAREVENTSV table. Also you can try: dbc.qrylogutilityv where utilityname='BAR'.  

 

For non-DSA backups, dbc.events table with eventtype='dump' would give this informatino.