How to change max server memory in SQL Server

Question

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?

Wesley · Accepted Answer · 2012-05-14 05:26:41Z

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.

Wesley

32.8k9 gold badges82 silver badges118 bronze badges

answered May 14, 2012 at 3:46

Taylor Jasko

6964 silver badges13 bronze badges

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, 2012 at 3:48
You should be able to start it with a simple "sqlservr.exe -f" in the command prompt.
– Taylor Jasko
May 14, 2012 at 3:53

Add a comment |

sivag · Accepted Answer · 2012-05-14 04:47:31Z

1

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.

answered May 14, 2012 at 4:47

sivag

443 bronze badges

Add a comment |

2 Answers 2