Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

audittrace.trc Expand / Collapse
Author
Message
Posted Tuesday, February 3, 2009 9:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 8, 2013 12:42 PM
Points: 10, Visits: 88
An error occured while writing an audit trace. SQL Server is shutting down. Check and correct error conditions such as insufficient disk space, and then restert the SQL server.

SQL Trace was stopped due to server shutdown.

Can someone help me. I have 255 G of free hardware space so why does SQL shut for insufficient disk space, please help.
Post #649016
Posted Tuesday, February 3, 2009 10:04 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
What drive is the C2 trace been written to? That's the drive that's out of space.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #649042
Posted Tuesday, February 3, 2009 10:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 8, 2013 12:42 PM
Points: 10, Visits: 88
I am saving the trace files in:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
and that is the disk with 255 G of free space?
Post #649074
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse