audit trace enables and sql server not starting

  • I restarted the sql server after c2 audit was enabled and now i can not start the instance getting this error below. how do i bring the sql server up?

    Cannot start C2 audit trace. SQL Server is shutting down. Error = 0x80070003(The system cannot find the path specified.)

  • i could not start the server in safe mode too, how do i disable the c2 auditing which i already enabled.

    Execute to disable C2 Audit mode

    sp_configure ‘c2 audit mode’,0

  • Check default locations for Data and Log files. In my case that was the issue.

    regedit

    HKEY_LOCAL_MACHINE --> SOFTWARE-->Microsoft-->Microsoft SQL Server-->

    DefaultData

    DefaultLog

    Cheers,

    Natalia

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

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