Skip to main content
commvault.com commvault.com
Question

Report of all restores for a particular SQL database

D
Bit
Forum|alt.badge.img+2

Hi, 

Can anyone please advise how I can find out when/where are database was restored to?  I’m talkign about SQL databases that might have restored in place, out of place or to a file. 

The DB I’m interested in will not have been restored to it’s original server but I need to know where else it may or may not have been restored.   

I have access to the Java GUI and the browser interface.  I can see a report called “Restore job summary” but that is a summary, I need to be able to filter by (source) database. 

Thanks 

 

A
Vaulter
Forum|alt.badge.img+15

Hello @davegray 

Thanks for the great question, if you are already in the Java console looking at the job you can right click » resubmit.

When you do this you will get a window open with all of the settings used in the restore. 
The issue with this is that it is a job by job basis and i think you can only do it for jobs in the past 14 days as we after that the CSDB drops the information from its tables. 

I hope it helps at least a little bit!

 

Kind regards

Albert Williams

The best way to learn anything, is to question everything
D
1 person likes this
  • D
    davegray
D
Bit
Forum|alt.badge.img+2
  • davegray
  • Bit
  • November 16, 2023

Hi @Albert Williams 

Thanks for your response. 

I really need to specify a DB (not server) and then get a report of all the date/time/location it has been restored to but it does not seem possible. 

It’s going to form part of our security audit where data has been restored to a non-approved/standard location. 

I might ping a message to CV support to see what they say. 

 

Thanks and have a good day. 

 

A
1 person likes this
  • A
    Albert Williams

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings