Tara-1044200
SSCoach
Points: 15951
More actions
August 12, 2014 at 11:31 am
#294365
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.)
August 12, 2014 at 12:10 pm
#1737310
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
ermolayeva
SSC Rookie
Points: 25
April 14, 2015 at 3:11 pm
#1790964
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