N
N
Nikita Shinkevich2019-12-11 03:04:14
System administration
Nikita Shinkevich, 2019-12-11 03:04:14

How to change the settings of the MS SQL 2014 server if the server does not start?

And again, my crooked hands bring to hemorrhoids...
MS SQL Server 2014, accidentally changed the maximum amount of RAM to 128 megabytes, after restarting the MSSQLSERVER service, it starts and immediately cuts off. You can't log in through Management Studio anymore, you can't change the parameter... How can I change the amount of maximum RAM for the server if it is not started? Is there a config file where I can fix it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
kisaa, 2019-12-11
@domres

Sad news:
https://social.msdn.microsoft.com/Forums/sqlserver...

>>Is there a way to change max memory in the Registry?
Changing memory settings using sp_configure does not require to reboot windows so I am assuming it is not stored in windows registry.
So answer is you **cannot**. That particular settings itself is probably stored in one of the system tables inside SQL server.

Even though the link says:
In this case a plain restart was not enough - SQL Server died because out of memory directly. I had to use -f to save the show.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question