We are trying to restore our master database. We cannot
get sql started in single user mode. We run the
sqlservr.exe -m from the command prompt (d:\mssql7) but
the SQL never starts. When viewing the error log the
master is started. However, the command prompt never
comes back after the statement. Here are the last few
lines of the error log.
2002-03-07 11:01:25.71 spid1 Recovery complete.
2002-03-07 11:01:25.71 spid1 SQL Server's Unicode
2002-03-07 11:01:25.71 spid1 'Binary Unicode
Collation' (ID = 33280).
2002-03-07 11:01:25.73 spid1 SQL Server's non-Unicode
sort order is:
2002-03-07 11:01:25.76 spid1 'bin_iso_1' (ID =
2002-03-07 11:01:25.76 spid1 SQL Server's non-Unicode
character set is:
2002-03-07 11:01:25.78 spid1 'iso_1' (ID = 1).