Select file files space

[cwb]

Helo my friends.

How i found backup file systems wich send database files...

Exemplo i have 2 nodes :

NODE_FS - send so FS
NODE_DB - send database.

I found many nodes (nodes_fs) send data bases files - so for this nodes i adjust exclude.

It's possible made a select in backup or file spaces table and find anothers nodes.


att

 

[chad_small]

You'd have to review the node by its occupancy. If you know it has a TDP node name then you should be able to determine that when the FS node has 800GB in backup storage that you are probably backing up data or log files. Trying to query the backup table is almost impossible.

 

[drivechip]

You might want to have a look to the filespaces of the nodes. Sometimes you can get an indicaton by the name and type. For example are DB TDP filespaces recognizable.