Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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.

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.

share|improve this answer

Your Answer

 
discard

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.