Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Resetting/deleting all LMS 2.5.1 databases

Is there a way I can reset the LMS 2.5.1 databases to factory default. Basically delete all the databases and start from scratch. I fouls rather not lose all my configuration settings like Single Sign On and users etc. I just want to delete all the devices from all the databases. Can't find anything in the docs or on cisco.com about this.

5 REPLIES
Red

Re: Resetting/deleting all LMS 2.5.1 databases

Are you running it on Windows or Solaris?

New Member

Re: Resetting/deleting all LMS 2.5.1 databases

Windows 2000

Red

Re: Resetting/deleting all LMS 2.5.1 databases

Please open a DOS shell and issue the command:

net stop crmdmgtd

Once you get the prompt back, open up the task manager and go to processes.

If any of these processes are listed, kill them manually:

sm_server

sm_authority

brstart

Now, go to CSCOpx\bin and issue the commands (case sensitive):

perl dbRestoreOrig.pl dsn=rmeng dmprefix=RME

perl dbRestoreOrig.pl dsn=cmf dmprefix=Cmf

perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM

perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV

perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH

Next, go to CSCOpx\campus\bin and issue the command:

perl reinitdb.pl -restore

To re-start the CiscoWorks application:

net start crmdmgtd

New Member

Re: Resetting/deleting all LMS 2.5.1 databases

Thanks

I have SSO and a master DCR with one slave server running campus manager. Do I have to do this on the slave too? Will I lose my configuration for SSO and my local user IDs? I guess I am asking if the configuration stuff is stored in the database too.

Red

Re: Resetting/deleting all LMS 2.5.1 databases

I believe that the settings are independent of the database. Just to be on the safe side, you may want to back up the databases prior to performing the re-init.

105
Views
15
Helpful
5
Replies
CreatePlease login to create content