Hi I am facing a problem with my ORION Network Perfomance Monitor, I already check the log file "C:\Program Files\Microsoft SQL Server\Mssql\DataMSSQL$SOLARWINDS\LOG" and I could found this "fspid74 CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed...

The nightly database maintenance job on our installation of Orion (8.1.0, on a virtual 64-bit sql server instance) consistently fails on the rebuild indexes step. The message in the job log is: "[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has been disconnected. You must reconnect...

I'm the DBA of a firm that's running Orion 8.1.0 in a dev enviroment - a virtual 64-bit sql server 2005 instance - before moving it to our prod database server. We started with MSDE, but Orion quickly outstripped the capabilities of that (at which point I became involved). We're having trouble...

Another way to view config from Cirrus. Idea. 1. Copy config from Cirrus database to Orion database. 2. Extract/view config from Orion database via Report writer(or any other SQL query). OpenOffice document, MSofiice document and 3 asp files inside. http://thwack.com/files/folders/orion_custom_views__orion_nodeinterface_views...

Can anyone tell me that complete requirements for the NetPerfMon User ID for the SQL Database? I am sharing a SQL database server and am having issues with the server team saying that the userid rights need to be changed. They want to remove the admin rights of the user id. Every thime they had done...

Is anyone else getting this error in their swdebugMaintenance.log file? (Yes, I have submitted a ticket to support). 2007-08-10 22:52:00,663 [5] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Finializing maintenance for VolumeUsage 2007-08-10 22:52:00,679 [5] ERROR SolarWinds.Data.DatabaseMaintenance...

Somehow I have some Orphaned Interfaces. Does anyone know how to clean that up? I'm assuming the SQL statement: UDPATE Interfaces DELETE * WHERE NodeID = '<NodeID of orphaned interfaces>' I know I have some, because I have a custom field that defaults to NULL and shouldn't be empty...

I have a fairly big Orion DB and there has been an I/O error on the hard drive. Now I can't "Attach..." the .mdf files I get a silly error from SQL 2005. So I like to know what my options are? Should I re-install and re-configure everything? Can I save part of my install? For example, can...

This report shows some WAN ckts > 45% use for a 5 min period. See pic. I have that working, but want to make it more readable by either doing a COUNT on the number of times the >45% hits or rolling those results into a link for the serial interface (some have hundreds of rows) or just showing the...

SQL questions for custom reports...The only lines I've added is in the WHERE section for <NodeID LIKE> part, which is a valid SQL query, but it causes the report to come back empty...any thoughts??? Also, I'm fairly new at SQL and the DateTime in the WHERE command is killing me. If I remove...