My Solarwinds Database is at 3.67 Gig and it has top saving historical Data, the database manager will not let me create a backup of the database. How can I clear some of my historical Data so I Can recover my database.
My Solarwinds Database is at 3.67 Gig and it has top saving historical Data, the database manager will not let me create a backup of the database. How can I clear some of my historical Data so I Can recover my database.
Hi Josequiroz,
If you are reaching the 4GB limit, you may need to look into moving your database to a SQL Server running Standard or Enterprise edition, as they will not limit your database size.
To reduce down the current size of your database, you can try the following:
Open the Orion System Manager, and go to File -> Orion NPM Settings. Under the database tab, you can choose how long to retain your statistics for - reduce these settings down to reduce the amount of polling and statistics data being retained.
On the same tab, you can start off a "Nightly maintenance" - this will go through the data in your tables and 'groom out' the data you no longer want to retain. Once this has completed, open the Database Manager tool (under database Utilities). Connect to your database server, right click on your database, and choose "Compact Database". This should reduce down the size of your database for you.
~ Caroline
Hi,
I have the same issue. I did try aging off data and compacting the database using the Database Manager, but I kept getting the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server] Could not allocate a new page for database 'NetPerfMon' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
I see that in Properties, data is taking 2.3 GB and the indexes are taking up 1.7, so that's how I'm hitting the 4 GB limit. Is there anything else I can try? Are there any objects in the filegroup I can drop and if so, how is that done? Thanks.
Steps to Truncate Syslog:
Truncate the table if you do not need to keep historical syslog messages
Open Database Manager
Start > All Programs > Solarwinds Orion > Database Utilities > Database Manager
If this is the first time you use the tool, add your database server by clicking on the Add server button.
Expand your database and right-click on the SysLog table.
Select Query Table.
Type the below SQL query:
TRUNCATE TABLE SysLog
and click on Refresh to execute the query.
This may take a while depending how many entries are recorded.
Once done, right-click on the database and select Compact Database.
Compacting a database shrinks it, reindexes it, and removes whitespace.
Hey guys,
Whilst I am not yet having any problems with my database, it is slowly creeping upto that size where I am starting to get worried, especially as we still need to grow our system to add more devices.
So my question is this, as I currently have a dedicated Win 2k3 Server running the NPM with SQL Express. Can I backup my DB stop all my services and install the Standard Edition of SQL and continue to use the same server to run the SQL DB and NPM? I only ask this as I would ideally like to keep the DB on the same server as the NPM Software itself, and also I don't really have any budget for a new server at the moment.
Any advise will be greatly appreciated.
Thanks
Dave
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.