InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 10:59:10 GMT20http://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspx[quote][b]opc.three (3/1/2013)[/b][hr]Nah, see my last post.[/quote]Yea got it. I replied before I read your post.Thanks again.SueTons.Fri, 01 Mar 2013 18:19:16 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspxNah, see my last post.Fri, 01 Mar 2013 17:58:53 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspx[quote][b]opc.three (3/1/2013)[/b][hr]No problem. One tweak for clarity. My query should have qualified the table with the new name of master, not master again:[code="sql"]SELECT *FROM [b][u]new_name_of_master[/u][/b].sys.configurationsWHERE name = 'max server memory (MB)';[/code][/quote]Yea, I think only way is to start services and check the memory settings.SueTons.Fri, 01 Mar 2013 17:50:59 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspxIf you connect to the Dedicated Admin Connection (DAC) you can run this query against the restored copy of master to retrieve the previous setting:[code="sql"]SELECT value AS [max server memory (MB)]FROM new_name_of_master.sys.sysobjvaluesWHERE valclass = 50 AND objid = 1544;[/code]Fri, 01 Mar 2013 17:48:09 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspxWas curious so just tried it myself but no dice. sys.configurations uses a rowset and a system view that eventually point back to the real master.Fri, 01 Mar 2013 17:35:39 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspxNo problem. One tweak for clarity. My query should have qualified the table with the new name of master, not master again:[code="sql"]SELECT *FROM [b][u]new_name_of_master[/u][/b].sys.configurationsWHERE name = 'max server memory (MB)';[/code]Fri, 01 Mar 2013 15:26:06 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspxThank you.SueTons.Fri, 01 Mar 2013 15:23:52 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspxNever tried it, but you could restore a backup of master with a different name to a running instance and issue:[code="sql"]SELECT *FROM master.sys.configurationsWHERE name = 'max server memory (MB)';[/code]Fri, 01 Mar 2013 15:08:34 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1425743-1550-1.aspxHow can I get a max server memory setting of SQL if it's not running/disalbled?SueTons.Fri, 01 Mar 2013 14:14:07 GMTSQLCrazyCertified