Link to home
Start Free TrialLog in
Avatar of bamapie
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.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.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of nmcdermaid
nmcdermaid

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bamapie
bamapie

ASKER

Looks good to me.  I'm too chicken to try it right now, but I will.