start sqlserver from the commnad line 1

[kindus]

While starting sqlserver from the command line, I am getting the following error

sqlserver could not find default instance, pl specify the name of an existing instance.

Question in the command there is no option of providing the instance name, rather it asked to provide fullpath for master datafile and errorlog, which I obviously did.

Am I missing something ??

thanks in advance

 

[tlbroadbent]

You need to use the -s option. BOL says:

-s option: Allows you to start a named instance of SQL Server 2000. Without the -s parameter set, the default instance will attempt to start. You must switch to the appropriate BINN directory for the instance at a command prompt before starting sqlservr.exe. For example, if Instance1 were to use \mssql$Instance1 for its binaries, the user must be in the \mssql$Instance1\binn directory to start sqlservr.exe-sinstance1. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[kindus]

thanks Terry very much