SQL Server 2008 log issue

Posted by George2 on Server Fault See other posts from Server Fault or by George2
Published on 2010-06-05T09:21:05Z Indexed on 2010/06/05 9:32 UTC
Read the original article Hit count: 769

Filed under:
|

Hello everyone,

I am using SQL Server 2008 Enterprise. Under logs folder, in my machine it is C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log, there are three kinds of files,

•ERRORLOG, ERRORLOG.1, ERRORLOG.2 ...    ERRORLOG.6;
•FDLAUNCHERRORLOG,    FDLAUNCHERRORLOG.1, FDLAUNCHERRORLOG.2,    ...FDLAUNCHERRORLOG.6;
•log_207.trc, log_208.trc, ...

My question is what are the differnet function of such log files? And why there are files ends with .1, .2, etc?

thanks in advance, George

© Server Fault or respective owner

SQL Server 2008 log issue

Posted by George2 on Stack Overflow See other posts from Stack Overflow or by George2
Published on 2010-06-05T08:14:46Z Indexed on 2010/06/05 8:22 UTC
Read the original article Hit count: 769

Filed under:
|

Hello everyone,

I am using SQL Server 2008 Enterprise. Under logs folder, in my machine it is C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log, there are three kinds of files,

  • ERRORLOG, ERRORLOG.1, ERRORLOG.2 ... ERRORLOG.6;
  • FDLAUNCHERRORLOG, FDLAUNCHERRORLOG.1, FDLAUNCHERRORLOG.2, ... FDLAUNCHERRORLOG.6;
  • log_207.trc, log_208.trc, ...

My question is what are the differnet function of such log files? And why there are files ends with .1, .2, etc?

thanks in advance, George

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about logging