Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

Single User Mode fails in SQL Server 2000 with ERRORLOG sharing er
I'm trying to restart SQL Server 2000 in single user mode from the command
line and receive this error:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr.exe -c -m

2006-11-29 09:58:59.78 server    initerrlog: Could not open error log file
'E:\P
rogram Files\Microsoft SQL  Server\MSSQL\log\ERR
ORLOG'. Operating system
error = 32(The process cannot access the file because it is being used by
another proces
s.).

I ran filemon on the ERRORLOG file and tried again.  I saw that the process
sqlservr.exe:2160 shows WRITE SUCCESS and then I try the single user mode
command and see sqlservr.exe:5036 OPEN SHARING VIOLATION.

So, does anyone know what's going on?

By the way, this is a clustered instance and the ERRORLOG is on a LUN on the
SAN, if that makes any difference.  I'm trying to manually restart SQL Serve
r
in single user mode to troubleshoot a system database restore issue from a
3rd party backup software.

Thanks,

David

Report this thread to moderator Post Follow-up to this message
Old Post
David
12-01-06 12:14 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 08:50 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006