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?