Command Line Prompt to Start SQL Server

This article has been archived. It is offered "as is" and will no longer be updated.
TechKnowledge Content

I have incorrectly set the memory setting in SQL Server and now the service will not start. What is the option to start SQL Server at the Command prompt of the server using the default memory settings?


Type in the following line at the Command prompt of the NT SQL Server:

sqlsrvr -c -dc:\sql60\data\master.dat -f

(where "-d" is the pathname to the master database)

You could also add these parameters using the Services window within the Control Panel, then start the MS SQL Server service.

This article was TechKnowledge Document ID: 1637

Article ID: 849642 - Last Review: 03/04/2014 05:28:39 - Revision: 3.0

  • Great Plains Dynamics 6.0
  • Great Plains eEnterprise 6.0
  • kbnosurvey kbarchive kbmbsmigrate KB849642