March 14, 2017 at 10:06 am
I am building a new 2012 server, and have been told to put certain parts of SQL onto certain drives to help with performance. I have managed to accomplish getting a number of items (tempdb mdf and ldf;
database mdfs/ldfs, backups, etc.) sorted out onto different drives, but I must have missed the section in the SQL install that allowed me to change the storage location for the SQL service logs and for the SQL Agent logs.
Since SQL is all installed now, is it possible to reconfigure WHERE the SQL logs and the SQL Agent logs will reside? Each of these logs is on the C: drive now and the DBA would like these logs to all be on a "log drive" that is sitting there empty at this time. I have not been required to make these different drive allocations before, so I could use a gentle guide - do I rerun the SQL install as a change, or use the T-SQL command to ALTER the database and reconfig the file locations or is it something else that is needed? Thanks.
March 14, 2017 at 10:14 am
You can find a way to change the location of the error logs here – https://sqlandme.com/2013/07/08/sql-server-how-to-change-sql-server-errorlog-location/. I have to admit that I never tried it. Also you wrote that the reason for this modification is performance, but I don't see how this will affect the performance.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 14, 2017 at 10:15 am
this should help;
https://www.mssqltips.com/sqlservertip/3093/how-to-change-the-sql-server-agent-log-file-path/
MCSE SQL Server 2012\2014\2016
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply