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

SIM running "backup log tempdb with no_log"

Paul C Cook
Occasional Visitor

SIM running "backup log tempdb with no_log"

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?
6 REPLIES
TheHawk
Occasional Visitor

Re: SIM running "backup log tempdb with no_log"

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.
Steve Cabiness
Occasional Visitor

Re: SIM running "backup log tempdb with no_log"

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.
rcseattle
Frequent Advisor

Re: SIM running "backup log tempdb with no_log"

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?
H.Y. Yiu
Frequent Advisor

Re: SIM running "backup log tempdb with no_log"

Exact same issue here.
Some pointers anyone?
mahesh jadhav
Occasional Visitor

Re: SIM running "backup log tempdb with no_log"

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.

rcseattle
Frequent Advisor

Re: SIM running "backup log tempdb with no_log"

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