question

RonNYC avatar image
RonNYC asked

Running sqlservr.exe -m -s SQLEXPRESS fails

When I run this I get: 2013-04-29 17:08:42.28 Server Error: 17058, Severity: 16, State: 1. 2013-04-29 17:08:42.28 Server initerrlog: Could not open error log file 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'. Operating system error = 32(The process cannot access the file because it is being used by another process.). BUT, I got this before I rebooted. There doesn't seem to be any other process accessing the error logs. I have removed any permission issues on these folders. RON
sql-server-2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KenJ avatar image
KenJ answered
Try running "handle" to see if you can identify any programs that have a handle to the file. You'll probably have to grab it from technet - http://technet.microsoft.com/en-us/sysinternals/bb896655.aspx Is there another instance that could be using the file? Is the instance already running before you run the command?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.