Maintenance Script

[tobycarver]

Oh, well, I'm hosted.

[Cubert]

Thats should not prevent us fixing you. Go grab my SQL Query plugin from http://www.plugins4labtech.com, It is under the free plugin section. Install and restart your LT console.


Afterwards launch SQL Query plugin from main view menu.

Put first query in as

Code: Select all

SHOW TABLES LIKE 'plugin_sw_chocolatey%';

This will return a list of tables names

next for each table name put in, replace TABLENAME with the actual table name

Code: Select all

DROP Table TABLENAME

[Cubert]

restart the DBagent after all tables are gone and it will re create them as current. then rerun the list tables command again to see tables back in database

[tobycarver]

OK, I was just missing the knowledge for the query. I have several results. Most are chocolateyii, but there's one that chocolatey1. I assume I drop all of them, yes? Will I need to reinstall the plugin?

[Cubert]

just the ones marked "ii", after wards just restart the dbagent for tables to be recreated.

No reinstall

[tobycarver]

I'm confused. I ran the command you gave early on to delete the maintenance scripts and it gave me the error. I just went in to look at the maintenance scripts as I could not remember anything related to chocolatey1 that was a result from the table query. When I expanded the maintenance scripts, all the chocolatey II script were gone. Not sure about that.

I went ahead and deleted the tables as well.

[Cubert]

now if you restart the dbagent it should recreate scripts and tables

[tobycarver]

All is well, thanks!