Solved

Error on FlightRecorderCurrent.trc.

Posted on 2009-05-19
8
5,052 Views
Last Modified: 2012-05-07
I am encountering the following error filling up the Event Viewer log
The SQL Server is a cluster system clustered on the OS side
"
An error occurred while writing a trace event to the file, \\?\\Microsoft SQL Server\MSSQL.2\OLAP\Log\FlightRecorderCurrent.trc.
"
Any idea why I am getting the error. Any help will be appreciated

Thanks
0
Comment
Question by:Greens8301
  • 4
  • 3
8 Comments
 
LVL 6

Expert Comment

by:bull_rider
ID: 24423116
0
 

Author Comment

by:Greens8301
ID: 24423592
Hi

The following snippet of .ini, could you tell me how to disable the flightrecorder which I like to try

Thanks

<FlightRecorder>
                  <Enabled>1</Enabled>
                  <FileSizeMB>10</FileSizeMB>
                  <LogDurationSec>3600</LogDurationSec>
                  <SnapshotFrequencySec>120</SnapshotFrequencySec>
                  <TraceDefinitionFile/>
                  <SnapshotDefinitionFile/>
            </FlightRecorder>

0
 
LVL 6

Accepted Solution

by:
bull_rider earned 500 total points
ID: 24423745
You just have to replace the 1 with 0

<Enabled>1</Enabled>

to

<Enabled>0</Enabled>
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:Greens8301
ID: 24424379
Thanks Thats what I thought

Do I need to bounce the service to take effect
0
 
LVL 6

Expert Comment

by:bull_rider
ID: 24424610
restart the service
0
 

Author Comment

by:Greens8301
ID: 24424887
Before restarting services to check if this fix resolves the issue, is there anything else you could think of that I can try/modify  before bouncing the services
Thanks
0
 

Author Comment

by:Greens8301
ID: 24427171
Thanks for the help
0
 
LVL 1

Expert Comment

by:Connecter
ID: 26272422
hi
i have the same problem could any one help and explain how to solve it and how to disable the flightrecorder

and also my c: drive is runing out of space
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Review MS SQL cluster diagram 9 89
Pivot Query Problem 9 41
why sql server only update some statistics in the database ? 3 22
convert null in sql server 12 34
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question