4

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?

7

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.

2
  • 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. May 14 '12 at 3:53
1

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

1.http://blog.sqlauthority.com/2009/02/10/sql-server-start-sql-server-instance-in-single-user-mode/

2.sp_configure 'Max Server Memory',1024 reconfigure

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

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.