SIM SQL database

[Andy Milewski]

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

[Rob Buxton]

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.

[Andy Milewski]

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

[Rob Buxton]

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

[Andy Milewski]

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

[Rob Buxton]

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.

[Andy Milewski]

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

[Rob Buxton]

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

[Andy Milewski]

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

[Rob Buxton]

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.