Adding MemToLeave -g Switch
Posted on 2008-11-06
[Sql Server 2005 SP-2]
Can I get some help with just the syntax of adding the -g switch to define CLR memory allocation?
The last bit of text in my startup parameters is the ".ldf" file. So I tried adding a space and the switch (so, "...ldf -g512") and I've tried no space ("...ldf-g512"). I can't start sql with either syntax.
The event log says:
FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf-g512 for file number 2. OS error: 2(The system cannot find the file specified.).
Where, exactly, do I put this switch, and what should it look like, exactly? I'm not getting this right, and I'm doing this on a production box (no, not by choice) so I can't keep stopping and starting sql.