topic Re: SIM SQL database in Server Management - Systems Insight Manager

SIM SQL database

Andy Milewski — Wed, 03 Mar 2004 14:53:56 GMT

having some problems with my mssql2000 sp3a SIM database. wondering if there is a way to reinstall a new database without uninstalling and reinstalling SIM

Re: SIM SQL database

Rob Buxton — Wed, 03 Mar 2004 14:59:45 GMT

Being that you'd lose the majority of your settings, what would you hope to achieve?

I'm still viewing HPSIM as a test environment until 4.1 comes out with the ability to import from IM 7. Until then I'm prepared to trash everything and start again.

But to answer your question, I know you can do the reverse but never heard of recreating the database.

Re: SIM SQL database

Andy Milewski — Wed, 03 Mar 2004 16:08:51 GMT

don't really care about content since this is a demo environment. just care that the database works properly. only have a few systems being managed by the CMS

Re: SIM SQL database

Rob Buxton — Wed, 03 Mar 2004 16:13:07 GMT

Andy,
Are the problems you're having the same ones you're having with the Agent / SNMP?

Re: SIM SQL database

Andy Milewski — Wed, 03 Mar 2004 16:15:06 GMT

no my SIM server that is having the problem is a w2k3 server. agents work fine on all my w2k3 servers. This database just doesn't want to work right for some reason. My other 5 are fine

Re: SIM SQL database

Rob Buxton — Wed, 03 Mar 2004 16:26:54 GMT

Are you looking at a complete reinstall of SQL Server or just to create a new blank IM Database?

If it's a reinstall of SQL, you could shutdown SIM, detach and save the database files, reinstall SQL and then copy the IM Database files back to the recreated structure and use SQL to attach them and finally restart IM.

There must be a part of the IM that creates the blank database but I don't know how to just invoke that.

Re: SIM SQL database

Andy Milewski — Wed, 03 Mar 2004 16:28:46 GMT

yes, looking to create a new blank IM database. SQL 2000 is fine just the IM database is corrupt. Seemed like it would be easier to install just a new IM db than reinstall all

Re: SIM SQL database

Rob Buxton — Wed, 03 Mar 2004 16:37:25 GMT

Out of interest, what's corrupt in the IM Database?

Re: SIM SQL database

Andy Milewski — Wed, 03 Mar 2004 16:43:04 GMT

having a problem with Insight_v1_0.ldf.
OVOW is providing the error for the SQL logs. sql complains about ldf not being available even though its there and is almost as large as mdf

Re: SIM SQL database

Rob Buxton — Wed, 03 Mar 2004 17:02:55 GMT

There was another forum item about large log files. And, I think there was a solution. Have a bit of a search, it may reveal something.