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?
Best Answer
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.