Errorlogs move after installing SP1 for SQL2K

  • neiljacobson

    SSCommitted

    Points: 1717

    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.

  • Andy Warren

    SSC Guru

    Points: 119676

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

    Andy

  • neiljacobson

    SSCommitted

    Points: 1717

    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 3 (of 3 total)

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