how to move Default SQL server trace location? (ERRORLOG)

• anzz

  SSCertifiable

  Points: 5503

  More actions

  July 5, 2016 at 4:53 pm

  #400359

  Hi folks,

  we have drive corrupted and have to move system databases and Default SQL server trace (ERRORLOG). can anyone please help with step to follow.

• kreuzer

  Ten Centuries

  Points: 1246

  More actions

  July 6, 2016 at 2:27 am

  #1888628

  Hi,

  this was the first hit with google:

  move ERRORLOG:

  https://blogs.msdn.microsoft.com/varund/2009/08/27/steps-to-change-the-default-location-of-sql-server-sql-server-agent-error-log-files/

  move system database:

  https://technet.microsoft.com/en-us/library/ms345408%28v=sql.110%29.aspx

  Or do you search something special?

  Kind regards,

  Andreas