topic Re: sql 2005 db is been moved in Server Management - Systems Insight Manager

sql 2005 db is been moved

srihpsim — Mon, 14 Jan 2013 03:40:08 GMT

Hi

our HPSIM database which is on sql server 2005 is been moved to new location which is also sql server 2005 i have also changed the location and db name in ODBC and database.props.txt but still not able to start the sim appliction and odbc connection to new locations shows me that the test is succesfully completed.

P.S. this thread has been moved from Insight Remote Support > general to ITRC HP Systems Insight Manager Forum - HP Forums moderator

Re: sql 2005 db is been moved

kurt Skjold Johannessen_1 — Mon, 25 Jan 2010 10:15:11 GMT

Hi There

There is a doc for how to do this did you follow that ??

ftp://ftp.compaq.com/pub/products/servers/management/hpsim/HowToSQL2005-sp2-MoveHPSIM53.pdf

Cheers

kurt Johannessen

Re: sql 2005 db is been moved

srihpsim — Thu, 28 Jan 2010 01:42:31 GMT

HI All

we need to change the location of SQLDB in hpsim application

- Backup original files and point the new SQLDB in these files (if it mentions the SIM DB): dbconfig.xml, databaseupdate.tpl hpvmmdb.conf, database.probs and databaseadminupd.tpl