Post reply

Event errors

  • December 2, 2015 at 4:07 am

    #322947

    Hi All,

    I unable trouble shooting following events in my error logs where databses are set to SQL DB mirroring recently.

    Message

    Setting database option SINGLE_USER to ON for database test

    Message

    Setting database option ALLOW_SNAPSHOT_ISOLATION to ON for database test.

    I have gone through couple of articles vefied following.

    1. No customer job set on the server to alter the database

    2. Verifed default trace details , found few results for object : Object:Altered for the database in question looks this calls are coming from application

    https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

    Please let know how can i find more details for detailed investigation . Suspecting application is trying to put the database as this.

  • December 2, 2015 at 5:28 am

    #1843462

    It seems to be application causing the issues while running some custom scripts. Since the database recently put on mirroring process is unable to do so.

    I am working with vendor to figureout to overcome this situation with HA solution.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply