Jack,

You are right. C2 audit trace was enabled. I am pretty sure this was done accidentally since there is nothing worth monitoring on that machine.

I have disabled the option...

Lowell,

Wow. Thanks. I had no idea this information existed. I ran the query: select * from sys.traces

idstatuspath

11\\?\E:\MSSQL\DATA\audittrace20091211104655_1581.trc

21C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_6507.trc

You mentioned that ID =1 is the default trace. In my...

Ok. I did it by brute force. I stopped Sql Server. Renamed the data file. When I brought Sql Server back up, the database was no longer marked as "suspect"...

Thank you, GSquared.

I should have just tried it myself and seen the error message. I sometimes just make things harder for myself just for fun. 🙂