Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server 2000 Standard Edition on Windows 2003

Author  Topic 

valliyil
Starting Member

8 Posts

Posted - 2005-03-29 : 04:03:37
I Installed SQL Server 2000 Standard Edition on Windows 2003 server Operating System. Also run the Service pack 3a.
I can't able to run the sqlserver in single user mode using sqlservr -m in command prompt. showing this error...

2005-03-24 07:42:56.40 server initerrlog: could not open error log file 'd:\MSSQL\log\ERRORLOG'. operating system error = 32 <The process cannot access the file because it is being used by another process.>.

please help me

kish
Starting Member

45 Posts

Posted - 2005-03-29 : 07:38:32
Is your SQL Server stopped ? If you are trying to start the sql server in single user mode, and your sql server is started, then it will give you error.

Kishore
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-03-29 : 14:56:55
Download process explorer and figure out what's holding onto the file. It's free and every DBA should have it.

http://www.sysinternals.com/ntw2k/freeware/procexp.shtml


MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -