Errorlogs move after installing SP1 for SQL2K

  • Something to watch. If you originally installed SQL 2000 to a directory such as C:\MSSQL but moved the errorlog to say E:\logs by changing the switch in EM, when you install SP1 the location resets to the original location. i.e. C:\MSSQL\LOG

    If this directory doesn't exist then SQL will not start after installing SP1.

    I have told Microsoft about this gotcha and they have confirmed it.

  • I have to ask - why would you move the error logs?

    Andy

  • I move the errorlog to be on the same RAID set as the database backups so I can copy to tape in one job.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply