Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter.

Now I can't even connect to the server.

Is there a way for me to reset the max server memory setting to the default value without connecting to the database server somehow?

share|improve this question

Just start SQL Server with the -f switch, which will start it in a minimal, single-user mode. You should be able to change it back afterwards.

share|improve this answer
I'm very beginner when it comes to this stuff. Can you give me a link that will show me how to do that? – Steven May 14 '12 at 3:48
You should be able to start it with a simple "sqlservr.exe -f" in the command prompt. – Taylor Jasko May 14 '12 at 3:53

Use this link to start sql server in single user mode and set max server memory by using following command.


2.sp_configure 'Max Server Memory',1024 reconfigure

When you are starting sql server in single user mode you have to disconnect all connections.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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