October 13, 2006 at 4:19 pm
Got a problem with the placement SQL Server Error Logs and a runaway process. The other DBA installed SQL on C:\ and I need to move these to a larger drive just in case the logs get too big again (due to this runaway process), and I don't want to reinstall SQL.
Can't seem to locate info on this (i.e. trace flags, reg hack?) Anyone have any info on this?
Thanks, Lezza
October 14, 2006 at 1:57 am
Lezza,
open SQL Server Configuration Manager, SQL Server Services and right click the SQL Server(MSSQLSERVER). Open properties and go the advanced tab. Under Startup Parameters replace the default errorlog path -eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG with the path you want like -eD:\Logfiles
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply