topic Re: SIM running "backup log tempdb with no_log" in Server Management - Systems Insight Manager

SIM running "backup log tempdb with no_log"

Paul C Cook — Mon, 04 Dec 2006 21:19:14 GMT

We are running SIM 5.0 SP5. The database is hosted on a separate SQL server (SQL 20000).

The SQL error log is showing the following error message "BACKUP failed to complete the command backup log tempdb with no_log". This happens between midnight and 2am every night and this is running as the user account that SIM uses. No other applications use this account.

You can't backup the transaction log for tempdb. My question is why is SIM trying to do this and how do I stop it?

Re: SIM running "backup log tempdb with no_log"

TheHawk — Mon, 14 May 2007 07:22:15 GMT

We have the same problem with SIM 5.1. Our DB team gets error messages and we get the following messages in our SIM log files:

12 Mai 2007 00:31:35,668 INFO [HPSIM_DEBUG] Error on db update java.sql.SQLException: BACKUP LOG permission denied in database 'tempdb'. backup log tempdb with no_log
12 Mai 2007 00:31:35,684 INFO [HPSIM_DEBUG] Error on db update java.sql.SQLException: User 'guest' does not have permission to run DBCC SHRINKDATABASE for database 'tempdb'. dbcc shrinkdatabase (tempdb)

It would be great, if there would be a possibility to disable this backup/shrinking function.

Re: SIM running "backup log tempdb with no_log"

Steve Cabiness — Wed, 30 Jul 2008 17:34:11 GMT

Has a configuration setting been identified to address this issue?

We're also encountering this issue with our SIM 5.1 SP1 installation with the SIM databases hosted on a separate SQL server (SQL 2000 SP4 HF 2040).

Any information would be much appreciated.

thanks,
-Steve C.

Re: SIM running "backup log tempdb with no_log"

rcseattle — Thu, 11 Dec 2008 22:41:42 GMT

SQL 2000 hosted on another server
HP SIM 5.1, Build version: C.05.01.00.00

"This happens between midnight and 2am every night and this is running as the user account that SIM uses. No other applications use this account."

Same issue

11 Dec 2008 00:13:19,080 INFO [HPSIM_DEBUG] Error on db update java.sql.SQLException: BACKUP LOG permission denied in database 'tempdb'. backup log tempdb with no_log
11 Dec 2008 00:13:19,158 INFO [HPSIM_DEBUG] Error on db update java.sql.SQLException: User 'guest' does not have permission to run DBCC SHRINKDATABASE for database 'tempdb'. dbcc shrinkdatabase (tempdb)

Same question. How can we stop this from happening?

Re: SIM running "backup log tempdb with no_log"

H.Y. Yiu — Wed, 14 Jan 2009 14:06:50 GMT

Exact same issue here.
Some pointers anyone?

Re: SIM running "backup log tempdb with no_log"

mahesh jadhav — Wed, 21 Jan 2009 10:03:25 GMT

Yes HP SIM will run the database shirnk taks by default. this some kind of house keeping sim do.Right now this can not be fully disabled, you can make SIM not do the nightly 2am cleanup. Doing so would include turning off other DB cleanup such as reindexing, historical data collection.

You can change the hour of the day this runs at, if set > 25 it just won't run daily. It still can get triggered during data collection. BTW, the defaut is 1 for the setting below.

mxglobalsettings -s
DbMaintenanceHourOfDay=30

Tells SIM to try and run the Database maintenence on the 30th hour of each day. Since there are only 24 hours this basically disables the auto cleanup call from running.

Re: SIM running "backup log tempdb with no_log"

rcseattle — Wed, 21 Jan 2009 17:16:04 GMT

Thank you, Mahesh, that was difficult to find. It looks like that was in the 5.2 HowTo file...
http://h10018.www1.hp.com/wwsolutions/misc/hpsim-helpfiles/readme_52.txt