You are viewing limited content. For full access, please sign in.

Question

Question

audit server issues alter database constantly

asked on October 17, 2017

On the sql server every few minutes we are seeing this sequence:

ALTER DATABASE [LFAudit] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Setting database option SINGLE_USER to ON for database 'LFAudit'

ALTER DATABASE [LFAudit] SET MULTI_USER WITH NO_WAIT
Setting database option MULTI_USER to ON for database 'LFAudit'

ALTER DATABASE [LFAudit] SET AUTO_CLOSE OFF
Setting database option AUTO_CLOSE to OFF for database 'LFAudit'

 

I turned off the audit server on the application server and then restarted it but these kept on coming in.

Last nights database backup of the audit database failed and I'm sure it was because it was in single user mode when the utility tried to run.

What is causing this and how do we stop it?

0 0

Answer

SELECTED ANSWER
replied on October 19, 2017

I fixed this by deleting the existing audit trail database and re-configuring audit trail and letting it create a new one.

 

0 0

Replies

replied on October 18, 2017

Rebooted both app and sql server, still getting these about every five minutes.

0 0
replied on October 18, 2017

Have you seen the related threads?

0 0
replied on October 19, 2017

Thanks for those links, the one said this was a known issue that is fixed in 10.2 and we are currently on 9.0.2 so it may pop up again until we upgrade.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.