<div>
When I execute this query, I can see the FileName in the output. Is it possible to modify the log file name ?<br />
<br />
SELECT <br />
&nbsp; &nbsp; DatabaseName,<br />
&nbsp; &nbsp; [FileName],<br />
&nbsp; &nbsp; SPID,<br />
&nbsp; &nbsp; Duration,<br />
&nbsp; &nbsp; StartTime,<br />
&nbsp; &nbsp; EndTime,<br />
&nbsp; &nbsp; FileType = CASE EventClass WHEN 92 THEN 'Data' ELSE 'Log' END<br />
&nbsp;FROM sys.fn_trace_gettable(@pat<wbr />h, DEFAULT)
</div>


When I execute this query, I can see the FileName in the output. Is it possible to modify the log file name ?

SELECT
    DatabaseName,
    [FileName],
    SPID,
    Duration,
    StartTime,
    EndTime,
    FileType = CASE EventClass WHEN 92 THEN 'Data' ELSE 'Log' END
 FROM sys.fn_trace_gettable(@path, DEFAULT)

<div>
It's possible but you need to stop the database to do that.<br />
<br />
But why you want to change a file name?
</div>


It's possible but you need to stop the database to do that.

But why you want to change a file name?

<div>
I have some other databases in the same server. <br />
But the log file names are generated with time stamp so I want to change the name to my log file.
</div>


I have some other databases in the same server.
But the log file names are generated with time stamp so I want to change the name to my log file.

<div>
Vitor Montalvão , <br />
<br />
For changing the log file should I have to stop SQL server service ?
</div>


Vitor Montalvão ,

For changing the log file should I have to stop SQL server service ?

<div>
No. You just need to stop the database that are using the log file. You can't do any operation on files if the database is online.
</div>


No. You just need to stop the database that are using the log file. You can't do any operation on files if the database is online.

<div>
<div class="content wysiwyg-content">
I am using SQL Server 2008 r2. How to &nbsp;modify &nbsp;the autogrow file name and size in SQL SERVER &nbsp;for my production Database &nbsp;?
</div>
</div>


I am using SQL Server 2008 r2. How to  modify  the autogrow file name and size in SQL SERVER  for my production Database  ?

How to set the autogrow file name and size in SQL SERVER for my production Database ?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.