Command Line Prompt to Start SQL Server

Article ID: 849642 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

TechKnowledge Content

Question

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?

Answer

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

Properties

Article ID: 849642 - Last Review: March 4, 2014 - Revision: 3.0
APPLIES TO
  • Great Plains Dynamics 6.0
  • Great Plains eEnterprise 6.0
Keywords: 
kbnosurvey kbarchive kbmbsmigrate KB849642

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com