SQL Server Performance

Wnat to restore master database --Giving error?

Discussion in 'SQL Server 2005 General DBA Questions' started by mssql_dba_123, Mar 18, 2009.

  1. mssql_dba_123 New Member

    Hi i want ot restore master database .
    FOr that i try to start my instance in single user mode....
    But give below error:
    C:program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn>sqlservr.exe - m -s TST_01
    2009-03-18 13:17:35.18 Server Authentication mode is WINDOWS-ONLY.
    2009-03-18 13:17:35.18 Server Error: 17112, Severity: 16, State: 1.
    2009-03-18 13:17:35.18 Server An invalid startup option was supplied, either from the registry or the command promp
    t. Correct or remove the option.
    Please help me.....
  2. techbabu303 New Member

    As error message states you have syntax error, are you sure TST_01 is instance name ?
    Also there should be no space between - and m

Share This Page