Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Recover deleted nodes

dennis.shiburi

Hi all

i want to ask if there is a way to recover deleted nodes.

Thanks

Find more posts tagged with

Accepted answers

All comments

tony.johnson

Hi Denis,

There is no in built functionality to recover deleted nodes, The only way, assuming you have a recent backup, would be a restore of the database to a point in time where the nodes existed, you would however also lose the historical data between restore time and time of backup.

Thanks,

Tony

dennis.shiburi

ok cool. thanks

adatole

Just a bit more info on this:

For Nodes, Interfaces, and Volumes, there is a related "deleted" table. For 24 hours after the deletion, you can find the node details in there. (and the supporting data records like collected values for CPU, RAM, bandwidth, errors, etc all stay in their respective tables.

At 2am (or whenever you change your database maintenance to run) those deleted tables are emptied, and any orphaned records in the other tables (again, CPU, RAM, etc) are removed.

So you CAN restore a node inside of the 24-hour mark, but not afterward.

superfly

Vote this up!

patriot

Ok, so what exactly would be the procedure to "recover" the node and its data? Adding the same node back to the database would do so with a different NodeID, so no connection to old data could be made there. ????

janene16

Restore the db, I suppose?

patriot

Restoring a database backup would of course work, but would also "restore" more than just deleted nodes and associated data. No, Leon Adato's response would lead one to think that there is a way to perform some kind of limited restore of just the data of interest, but I cannot imagine what that process would be. Hence, my question.