topic Re: Database Integrity Tool in Server Management - Systems Insight Manager

Database Integrity Tool

Annette Jones_2 — Thu, 08 Mar 2007 10:02:18 GMT

All, I have lost the variable system name when creating system lists, and all the details from existing lists dont appear when customising. The database is held in a separare SQL server, does anyone know of any tools to run incase its a quick fix on the database?

Re: Database Integrity Tool

Darrin Rawls — Thu, 08 Mar 2007 18:07:13 GMT

Try looking at the CLI command mxconfigrepo (in the help).

mxconfigrepo -f checks the db for corruption

Re: Database Integrity Tool

Annette Jones_2 — Fri, 09 Mar 2007 04:00:41 GMT

Darrin,

How does that check for corruption when the SQL database resides an another server, can you explain the process.

Regards
A

Re: Database Integrity Tool

Darrin Rawls — Fri, 09 Mar 2007 09:35:59 GMT

It doesn't matter where the db is located. SIM has a connection to its database regardless of location. That command checks for data integrity within the SIM tables itself.

Re: Database Integrity Tool

Annette Jones_2 — Fri, 09 Mar 2007 09:57:59 GMT

Ok, thanks, this doesn't help me then, cause I have laredy run this tool, although it did pick up a few things and fix, it didn't fix the problem with me not being able to add and edit systems lists.