Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

HP SIM 5.1 with MS SQL 2005 as backend

HP SIM 5.1 with MS SQL 2005 as backend

Hello.

I have been running this configuration for some tiem, but I have noticed that the DB file and Transaction log file has turned BIG !!

What is the best practise DB setting for HP SIM DB ?
Simple, Bulk or Full recovery mode ?

I hope that someone can help me with this.
2 REPLIES
James ~ Happy Dude
Honored Contributor

Re: HP SIM 5.1 with MS SQL 2005 as backend

Hello Trond,
Perhaps this might help you:

h71028.www7.hp.com/ERC/downloads/4AA1-1028ENW.pdf

Regards.
fred Passeron
Honored Contributor

Re: HP SIM 5.1 with MS SQL 2005 as backend

Hi

As a common usage, I don't think any special setting is needed for the DB itself.

Regarding the transaction log settings, make sure recover mode is set to Simple from SQL enterprise manager.

You can also check this doc :
http://h20000.www2.hp.com/bc/docs/support/SupportManual/c00809568/c00809568.pdf


hope it helps

fred





“Life is pleasant. Death is peaceful. It's the transition that's troublesome.” Isaac Asimov