bamapie
asked on
Adding MemToLeave -g Switch
[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.ld f-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.
Thanks.
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\
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER