Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Backup and Recovery Community Blog

SQL Query for the Backup Exec catalog filename checking.

Backup Exec
Created: 06 Apr 2014 • Updated: 08 Apr 2014 • 3 comments
Daeyoung_Chun's picture
+3 3 Votes
Login to vote

I want to share the following simple tip.
This is to query the BE SQL DB(BEDB) for check the file name for the catalog.
This information will not be directly supported by Symantec.
In addition, this feature is not available directly from Backup Exec.
Symantec is not responsible for any issue caused by a use of it as well.

select cr.MachineName,
       cr.ResourceName,
       ci.HistoryFileName,
       ci.ImageName,
       cm.MediaName,
       ci.EngineName,
       cf.MediaID,
       ci.ImageNumber,
       cm.CartridgeLabel,
       cm.MediaType,
       cm.Location,
       cm.RelativeLocation,
       cm.CreationDateTime,
       ci.NumBytes
      
from CatImage ci join CatResource cr on cr.ResourceID = ci.ResourceID
   join CatFragment cf on cf.ImageID = ci.ImageID
   join CatMedia cm on cm.MediaID = cf.MediaID
   
where cr.MachineName like '%HOSTNAME%'

order by ci.HistoryFileName, cr.ResourceName

The result is:
(In the example, used to search for the host name of VCENTER.)

feature01_2.jpg

Can be used even when you want to keep together with catalog data of replicated backup data to tape media for DR or long-term keep for a specific host.
May not need some of the information is output.
The purpose of this query is to extract the file name in the catalog.
To do this, you may need to install the Microsoft SQL Server Management Studio additionally.
Required the SQL2005 or higher version management console the because using the SQL2005 Express Edition in BE2010 and BE2012.
And you can use the ScanFS utilities for in order to more easily work(perform the copy or move multiple files at once) with.
(ScanFS utility are download via Google search.)

You need some data processing tasks after the SQL query.

  1. Copy the contents of HistoryFileName field.
  2. Paste to the text editor such as Notepad or Wordpad
  3. Use the Replace(Ctrl + H) function to change the ‘.fh’ to ‘.xml'.
    feature03.jpg
  4. Once more paste the copy contents to bottom part.
    feature02.jpg
  5. Copy of all contents.
  6. Run the ScanFS (Shareware utility) and paste to ‘Define search criteria’ window of copied all contents.
    feature04.jpg
  7. Define to catalog location to search of Directory field.
  8. Click to Disk Search
    feature06.jpg

The End.

Regards,

Comments 3 CommentsJump to latest comment

CraigV's picture

...nicely done!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

0
Login to vote
iBackupExec's picture

Thanks you for sharing! V nice! yes

~V

0
Login to vote