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.
bamapieAsked:
Who is Participating?
 
nmcdermaidConnect With a Mentor Commented:
Looking in SQL Server Configurtaion Manager (Start Menu/SQL Server/Configuration Tools/SQL Server Services/SQL Server/Properties/Advanced/Startup Parameters), my parameters look like this:
 -dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Following the same format I expect that you need to do this:
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;g1024
assuming you want to set g to 1024.
0
 
bamapieAuthor Commented:
Looks good to me.  I'm too chicken to try it right now, but I will.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.