How returns lost memory to sql server

One day I made a mistake. I set the sql server memory to 8MB instead of 8000MB. by using management studio. After this smart action sql server immediately went down. What now?

C:\Program File...\MSSQL\Binn>sqlservr.exe -dD:\MSSQL13.<INSTANCE>\MSSQL\DATA\master.mdf -eD:\MSSQL13.<INSTANCE>\MSSQL\Log\ERRORLOG -lL:\MSSQL13.<INSTANCE>\MSSQL\DATA\mastlog.ldf -f -s <SERVER>\<INSTANCE>
C:\Program File...\MSSQL\Binn>sqlcmd -E -S <SERVERNAME>\<INSTANCE>
1> EXEC sp_configure 'max server memory', 8000;
2> GO


Leave a Reply

Your email address will not be published. Required fields are marked *