truncate data from SQL database

davidb1

So here is just a brief description of the problem. Im having an issue with the SQL database getting to full. I know the long term solution it to upgrade my SQL server license to allow for more then 4gigs of storage but hey im working on a budget here Anyways once the database gets full the polling engine stops working even tho the engine stay up and running, the charts in the webconsole stop updating. I know the fix for the issue it to truncate the data in the SQL database but i cant remember where in the Studio Manager to go to perform this action. Could someone please point me in the right direction? Iv hit a roadblock in my mind and i completely forgot where to delete the trap data and events in the SQL database.

 

By the way I'm running SQL 2005 Standard on a Windows 2003 server.

 

Thanks in advance.

davidb1

Ahh I figured out the answer to my own question. But just in case anyone else searching the forms for the same issue just do the following:

 

Go to Start> Programs> Solarwinds Orion> Advance Features> Database Manager

Once it opens and your database is connected. Look at your database tables and delete what is least important data to free up some database space. In my case i didnt need to see the CPU Load details. So right mouse click on the table element and query that table. Once it opens up, remove what text might be in the box, and just type [TRUNCATE TABLE CPULoad_Daily] without the brackets and hit your refresh button at the top.

 

This will remove the data in that table and free up some space in your database. Just be aware of what your removing and make sure its data you do not need.