Windows 2003, Sql Server 2005 (SP2 3042)
Was DRP'ing a server over the weekend and was not able to start sql server in single user mode. From the Binn directory I ran
sqlservr.exe -m and everything appeared to be ok but the restore failed with the database must be in single user - did a work around to get things going.
Come monday I'm and testing this on a test system, same thing happens, however if I start sql server using 'net start mssqlserver /m'
it starts in single user mode everything works fine
What could be the issue with sqlservr.exe?