HPE Community
Server Management - Systems Insight Manager
1833832 Members
2278 Online
110063 Solutions
New Discussion

HP SIM 5.1 with MS SQL 2005 as backend

 
Trond E. Gjelsvik-Bakke
Advisor

‎11-23-2007 01:31 AM

‎11-23-2007 01:31 AM

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.
0 Kudos
Reply
2 REPLIES 2
James ~ Happy Dude
Honored Contributor

‎11-23-2007 04:51 AM

‎11-23-2007 04:51 AM

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.
0 Kudos
Reply
fred Passeron
HPE Pro

‎11-23-2007 05:03 AM

‎11-23-2007 05:03 AM

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
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.