4

There was a local SQL Server 2012 instance. Once memory has decreased to critical 128 MB and then has stopped by me.

I can not start it (idea: not enough memory).

Is it possible to increase this limit in config file or in system registry?

6
  1. Open SQL Server Configuration Manager
  2. In the SQL Server Services pane, locate the instance that has the problem
  3. Right-click that instance and select Properties
  4. On the Startup Parameters tab, type -f, click Add, then click Apply
  5. Right-click that instance and select Start (or Restart)

This will start the instance in minimal configuration mode (single user, no CHECKPOINT, and no startup procedures are run), which should allow you enough resources to connect and fix what you broke.

  • Aaron it would worth adding in answer that after starting SQL Server please change max server memory to optimum value so that next time this issue does not happens – Shanky May 13 '15 at 16:25
  • Your answer + fast clicking (to be first) + this article: msdn.microsoft.com/en-us/library/ms178067.aspx = solution. Thanks! – Aleksandro M Granda May 13 '15 at 16:26
  • @Shanky That is what I meant by "fix what you broke." – Aaron Bertrand May 13 '15 at 16:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.